AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N36KSKelley Ronald C · Deer Lodge, MTN36KTSunset Ridge Home & Hardware Ll · San Antonio, TXN36KWEastern Aviation Publishing Inc · Center Harbor, NHN36LABrinson Jack E Jr · Raleigh, NCN36LFBonacia Aviation LLC · Reno, NVN36LGShirley George P · Rutledge, TNN36LHJackson Aviators LLC · Nashville, TNN36LLBeech Bums Aviation II LLC · Linden, MIN36LMN36lm LLC · Spicewood, TXN36LPMyers Aviation Inc · Oshkosh, WIN36LRQuarter Circle E Enterprises Inc · Yorba Linda, CAN36LXQualitair LLC Trustee · MichelstadtN36MMsl Group LLC · Waxhaw, NCN36MBBritcliffe Michael J · Pasadena, CAN36MDWoods Aviation LLC · Elnora, INN36MJFinland Leasing Co Inc · Quakertown, PAN36MNKad Enterprises LLC · Everett, WAN36MSFlying Medical Service Inc · Grosse Pointe, MIN36MTLesko Brady · Lusby, MDN36MYRla Llp · San Jose, CAN36MZWestfall Thadd W · Three Lakes, WIN36NCrossman Kyle D · Monroe, MIN36NBCl Holdings LLC · Washington, DCN36NHAlgar Linda · Tucson, AZN36NMFrost Cavin Bert · Odessa, TXN36NSHoversen Eric · Saint Augustine, FLN36PATrevathan Max Tyler · Dyersburg, TNN36PCBoyd David · Encino, CAN36PDHigh Flyers LLC · San Luis Obispo, CAN36PFFoley Philip · Rathdrum, IDN36PKGoodman Ronald · Dos Palos, CAN36PVLong Wing Aviation LLC · Houston, TXN36PWHanks Stephen W · Arroyo Seco, NMN36PYMoore Gary E · Crossville, TNN36PZFillips Robert Victor · Alvin, TXN36QSchindler Donald G · Springfield, ORN36QMFlight Solutions LLC · Columbia, MON36RBEngelmann Randal · West Palm Beach, FLN36RCAiken Air Sales And Rentals LLC · Aiken, SCN36RDProflight Inc · Wilmington, DEN36RFBeverly Air Transport Co · Chicago, ILN36RWBas Part Sales LLC · Greeley, CON36SValaco Inc · Albertville, ALN36SBWollenberg Jeffrey · Concrete, WAN36SCEdwards Thomas E · Brighton, CON36SERegistered aircraftN36SRBerg Steven A · Vero Beach, FLN36SSFournier Ronald C · Killeen, TXN36STGriffith Joshua S · Breckenridge, TXN36TEGary Vaughan Construction Inc · Leland, MS
Back to AD 2007-04-19 R1