AD 81-18-04 R2
Registered aircraft · 81,733
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N7250JBrandenburg Carl A Jr · Goodyear, AZN7250PTrayer Kevin B Trustee · Haslet, TXN7250QSale Reported · Crystal, MNSale reported, pending cancellationN7250WHuber Peter Michael · Pulaski, VAN7251FWright Charles W · Selbyville, DEN7251JChapman Michael S · Cardington, OHN7251QGarcia Crystal M · Brownsville, ORN7252GLeaders Flying Service LLC · Clear Lake, MNN7252JMedina Jose · Spring, TXN7252KEgan Bailey J · Forsyth, MTN7252LForney Luke N · David City, NEN7252PSchaefer Hugh W · Merrick, NYN7252QRobbins Aviation LLC · Scottsbluff, NEN7252SDorris Joseph · Lewisburg, KYN7252YGuyer James · Billings, MTN7252ZAerial Banners Inc · Pembroke Pines, FLN72535Root Angelo R · Orovada, NVN7253GOne Mile LLC · Canton, GAN7253JLeffler William J · Tucson, AZN7253QHarry'S Hawks · Wells, MNN7253WGross Matthew A · Ridgecrest, CAN7253YJednacz Scott T · Bixby, OKFirst renewal noticeN7254FWolf Kim A · East Wenatchee, WAN7254HVevani Aircraft LLC · Miami Gardens, FLN7254JMinkel Chad A · Chanhassen, MNN7254KCook Tim L · Eagle River, AKN7254QRegistration Pending · Phoenix, AZRegistration pendingN7254WMonroe County Flyers And Sales LLC · Sweetwater, TNN7254YSpldkd LLC · New Richmond, WIN72551Gonzalez Christian · Manati, PRN72553Whittom Ron W Jr · Wasilla, AKN72559Welch Paul · Oldsmar, FLN7255FN7255f LLC · Cedar City, UTN7255JRury Bryan · Midlothian, TXN7255LHall Travis J · Dayton, TNN7255PKubik Rodrick D · Waukee, IAFirst renewal noticeN7255QSierra Sky Aviation LLC · Kalispell, MTN7255ZCentral Ms Soaring Society LLC · Brandon, MSN7256FZihala William · North Little Rock, ARN7256GAvstar Inc · Seattle, WAN7256HChaparral Aviation LLC · Edmond, OKN7256LRegistration Pending · Fair Bluff, NCRegistration pendingN7256QAustin Ferrel Stephen · West Monroe, LAN7256WRoswall James B · Bristol, TNN7256YGupta Vivek · Shelton, CTN72579Allee Mark J · Gillette, WYN7257DArctic Aero LLC · North Pole, AKN7257EAerospring Leasing LLC · Wasilla, AKN7257FHedberg Jacob R · Jordan, MNN7257JHardin John M · Terrell, TX
Back to AD 81-18-04 R2