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.
N2185ULethin Savanna C · Anchorage, AKN218CCSotally Tober LLC · Wilmington, DEN219BTDacy Justin A · Boerne, TXN21BESpecialized Helicopter Training LLC · Middleton, IDN21BMGandee James T · Bullhead City, AZN21CTFerreira Douglas B Trustee · Chico, CAN21KRNorcon Enterprises Inc · Amarillo, TXFirst renewal noticeN21LTMission Flight · El Monte, CAN21RGMacair Aviation LLC · Xenia, OHN2206RKahonees Travel Services LLC · Pleasanton, TXN2209RPilotsgirl LLC · Goldsboro, NCN220TSouthern Aircraft Consultancy Inc Trustee · Casper, WYN220TJJaco Oil Co · Bakersfield, CAN220WBWells Propane Inc · Wells, NVN2210RCarroll James K · Paso Robles, CAN22121Registration Pending · Georgetown, TXRegistration pendingN2216FSummit North LLC · Anchorage, AKN2216URegistered aircraftN2217RParke Mike D · Twin Falls, IDN221AARegistered aircraftN221JEElgee John O · Anchorage, AKN22202Gifford Gregory L · Naples, FLN2220SSb Meridian LLC · Heber, CAN22232Engeseth James Jr · Parker, CON2223SDavis Aaron B · Lascassas, TNN2226RChampion Crane Service Inc · Des Moines, IAN2226SE S P Aviation LLC · Wilmington, DEN2228SHannaford Edward M · Roseville, MIN2229SKey Lime Consultants LLC · Wilmington, DEN222ATSierra 1 Tech Inc · Blue Jay, CAN222ETValiair Lc Trustee · Casper, WYN222LSLj Bickford Companies LLC · Wasilla, AKN222MHJones Jimmy N · Bremond, TXN222SGPacific Aviation Aircraft Management Inc · Fresno, CAN222SJTriple Deuce LLC · Harrisonville, MON2233SRichardson Robert O · Spring Grove, ILN2234RJones Lennis William III · Rule, TXN2235SN2235s LLC · Overland Park, KSN2236RSouthern Skies Aviation Inc · Cedar City, UTN22396Jordan Lennon D · Bartow, FLN223SCSurdex Corp · Chesterfield, MON2241RHappy Landings Aero LLC · Wilmington, DEN2241SEdmondson James K · Lemoore, CAN22459Hatch Leasing Company LLC · Flagstaff, AZN2246RMontgomery Brian · Houston, TXN2247SCarnes Andrew P · Wichita Falls, TXN2248RVan Heemst Jeffrey A · West Palm Beach, FLFirst renewal noticeN2249SDlw Flight Services LLC · Waterloo, ILN224KAChambers William Melvin Jr · Azle, TXN224MHFeely Daniel R · Pasadena, CA
Back to AD 2002-07-01