AD 2002-07-01
Registered aircraft · 3,466
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:2002-07-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01')
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:2002-07-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01') 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.
N5799JBritt Demolition And Recycling Inc · Hanceville, ALN57AMclallen Holdings LLC · Saint Charles, ILN5821FFlite Five Inc · Kiowa, KSN5822FGrein David A · Mokena, ILN5827FBok Hans · North Dartmouth, MAN5828FKissell Ryan · Mount Vernon, OHN5829FMoa Klinton J · Bellingham, WAN5830FSuchy Karel · Kenosha, WIN5833FVermillion Fc-1 LLC · Crystal City, TXN5842FHci Properties LLC · Frankston, TXN5843FU3 Aviation LLC · Little Rock, ARN58441Tall Timber Flying Service LLC · Kalispell, MTN58466Aerial Transport LLC · Dover, DEN58502H E Fly Float LLC · Virginia Beach, VAN5850F5850f LLC · Monroe Township, NJN5852FAlvidrez Investments Group Inc · Lakewood, CAN5855FOrmiston Air LLC · Kismet, KSN5860FThomas Kirk F · Corpus Christi, TXN5864FSkaw Jack E · New Auburn, WIN5867FIndigo Of South Fl Inc · Sunrise, FLN5869FCavanaugh Gerald R · Friendswood, TXN5872FStearns Edwin B Jr · Chandler, AZN5873FWehrman George · Covina, CAN5878FVanreeth Philip J Jr · Woodstock, ILN5887FDe Leon Christopher · Donna, TXN5888CCwf Enterprises Inc · Grove, OKN589JSWings West Consulting LLC · Mesa, AZN58BDBravan Aviation Inc · Fort Lauderdale, FLN58DJPtc Financial Inc · Wilmington, DEFirst renewal noticeN58MARagan Edwin E III · Austin, TXN58TTBank Of Utah Trustee · Salt Lake City, UTN59007Hang On LLC · Montrose, CON59008Davis Burton D · Jefferson, IAN59011Nelson Albert N III · Baytown, TXN5902FPeters Kenneth R · Plainfield, ILN59041Edwards Aviation & Consulting LLC · Broken Arrow, OKN59045Air-Zancada Inc · Wilmington, DEN59049Scarry David Charles · San Luis Obispo, CAN5904FRegistered aircraftN59060Agriflite Services Inc · Wakarusa, INN59073Hartenstine Michael Carl · Lancaster, CAN5907FIsland City Seaplanes Inc · Cordova, AKN5908FCharger Aviation LLC · Chariton, IAN5909FHendrix Benton · Eckley, CON59105Allen Willis M Jr · El Cajon, CAN59141Peters Mark E · Newport News, VAN59146Universal Charter Service Inc · Auburn, CAN5915FJeffries Phillip L · Belington, WVN59164Marine Electrical & Refrigeration Of Kodiak LLC · Kodiak, AKN5916FTlc Flying Inc · Colfax, WA
Back to AD 2002-07-01