AD 2000-06-01
Registered aircraft · 39,302
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:2000-06-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:2000-06-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:2000-06-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:2000-06-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.
N10RHGoodson David · Millbrook, ALN10RP4f Aviation LLC · Palmer Lake, CON10SBSackett Michael · Nordman, IDN10TTHays John J Jr · Denton, TXN10TUAction Aviation LLC · Idaho Falls, IDN10VFAce Aircraft Leasing Inc · Nazareth, PAN10XCMontgomery Jerry J Jr · Charlotte, NCN10YSeitz William D · Gordonville, TXN10YTN10yt LLC · Missoula, MTN10ZTVliegtuig LLC · Plattsmouth, NEN1100UThomas Jennifer G · Dayton, OHN1101CHampton Brock W · Wichita, KSN1102ALemon Gordon J · Edmond, OKN1102CWakefield Aviation LLC · Mahopac, NYN1102FGrant County State Bank · Carson, NDN1102GGlassy Water LLC · Brier, WAN1102MEls Dennis J · Centralia, ILN1103MFlying M Enterprises · Loomis, NEN1104FMiller Jonathan A · Apo, APN1104MCarrolls Auto & Aircraft LLC · Muncie, INN1105CLandon Jeff · Lancaster, CAN1105FGibbard Donald R · Walla Walla, WAN1107FMedic Choppers LLC · Springdale, ARN1108FAom Aircraft LLC · Wilmington, DEN11092Mikulichek Richard L · Silver Lake, MNN11097Airborne Aviation LLC · Anchorage, AKN1109MPatrick Chris J · Paris, ILN1109USky Quest Inc · Wilmington, DEN110AUHernandez-Santiago Ruben A · Ponce, PRN110BDArgus Craig J · Atlantic City, NJN110BXCk Leasing Services LLC · Wilmington, DEN110DWSlater Spray Service Inc · Maddock, NDN110EACenterline Holdings · Camden, DEN110FMHorton Maya Patryce · Phoenix, AZN110FSMaggie L Air Service LLC · Kalispell, MTN110HPColt 45 LLC · Tulsa, OKN110KMCars Planes And Land LLC · Fuquay Varina, NCN110NJState Of New Jersey · Trenton, NJN110NPJungemann Jeff D · Brigham City, UTN110PFUniversity Of Detroit Flying Club Inc · Livonia, MIN110RJMathias Ralph · Long Beach, CAN110RLProctor Charles L · Alachua, FLN110SBCreamer Leon Eugene · West Jefferson, OHN110SMPenhall Michael Joseph · Lake Forest, CAN110SSEdwards Pacific Aviation Corp · Dover, DEN110TKSchnorf Curt L · Centerview, MON110USZwainz Thomas G · Reardan, WAN110YDLloyd Clee · Canby, ORN11103Hennigan Shellie · Jonesboro, LAN11104Elliott Frank F · Mojave, CAFirst renewal notice
Back to AD 2000-06-01