AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
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:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') 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.
N52859Wehrs Aviation LLC · Johnsburg, ILN5285DBarker Aviation LLC · Ardmore, OKN5285HChild Cris · Mapleton, UTN5285KBoland Mark J · Anchorage, AKN5285QBartell Kevin W · Abbottstown, PAN5285RPuddle Jumper Aviation LLC · Brighton, CON5285UShroyer Jayme D · Longmont, CON5285VMiddletown Regional Flight Training Institute LLC · Middletown, OHN52861Holst Thomas C · Pleasant Hope, MON52862Klosterman Sean M · Seattle, WAN52863Swodeck John · Gilbert, AZN52866Egan Bailey J · Forsyth, MTN5286CUnited Flying Club Inc · Belmont, CAN5286EButler Bill · Juntura, ORN5286HNieves Irvyn T · Vega Baja, PRN5286QPasterski Mark F · Chicago, ILN52871North Cardinal LLC · Crookston, MNN52873Pepper Daniel J · Henderson, TXN52876Noteboom Mike · Orange City, IAN52877Weight Malcom E · Spanish Fork, UTN52878Martin Carver Jessica · Bowling Green, KYN5287ATax Busters Inc · El Paso, TXN5287DWitham Kyle S · Lakeview, ORN5287ELin LLC · Dunn, NCN5287QRice James L · Mckinney, TXN5287YMorrow Aviation LLC · Midland, TXN52880Matta Sam · Houston, TXN52881Cardinal Air · Gold Hill, NCN52882Qdp Inc · Cincinnati, OHN52884Smith Eric Von Trustee · Vallejo, CAFirst renewal noticeN52885Foster David F · Potomac, MDN52886Gilbert Jack M · Visalia, CAN52888Alphadelta Aviation LLC · East Windsor, CTN52889Waters Steven D · Kingwood, TXN5288QErnie Hall Aviation Museum Inc · Warren, OHN5288TG & S Air Adventures LLC · Jersey City, NJN52890Schlafly Sheila B · Miami, FLN52891Registered aircraftN52894Craren Michael J · Holliston, MAN52895Marshall Brian L · Hays, KSN52899Kalogerson George G Trustee · Eden Prairie, MNN5289EFlightco Inc · Swainsboro, GAN5289QNielson Douglas W · East Troy, WIN528CPCivil Air Patrol · Maxwell Afb, ALN528ERMary Air LLC · White Rock, NMN528ESBraner Dana A · Portland, ORN528KCBukhart Don · Blakely Island, WAN528LDCar Two Charlie LLC · Lewes, DEN528LEZeus Aviation LLC · Carlisle, OHN528MJAircraft Owners & Pilots Association · Frederick, MD
Back to AD 79-10-14 R1