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.
N3678WDiamond B Farm Inc · Gamaliel, KYFirst renewal noticeN3678XS&S Aircraft LLC · Cushing, OKN3678YDozier Zach J · New Boston, TXN3679DCheney Joseph F · Daphne, ALN3679PFountain Craig T · Moscow, IDN3679UPowerhouse Coach Inc · Idaho Falls, IDN3679ZKlein Eric · Tenino, WAN367ATL&R Aircrafts Corp · Boynton Beach, FLN367BCVc Air LLC · Midland, TXN367BMWilliams Richard · Atlanta, GAN367CCUsda-Aphis-Ws · Cedar City, UTN367CTCoast Flight Training And Management Inc · San Diego, CAN367DMarquardt James H · Warner Robins, GAN367DEHour Time Aviation LLC · Granbury, TXN367EZMeggs Benjamin R III · Fort Worth, TXN367HPN367hp LLC · Aberdeen, SDN367HRArrow Flight LLC · Baton Rouge, LAN367LALead Aviation Fl3 LLC · Osprey, FLN367LRLa Rotta Tony · Pembroke Pines, FLN367MAMindy Limited LLC · Muscatine, IAN367MKNorth Star Aviation Inc · Mankato, MNN367MSMoeller Nathan Peter · Las Vegas, NVN367PCReynolds Doug · Huntington, WVN367RWSpies Robert Charles Sr · Kingman, AZN367SABrien D Stockman Pa · Logan, KSN367TCRegistered aircraftN367TJFlorida Aerial Services Inc · Lutz, FLN367VSellick Lawrence D · Phelps, NYN367WEvans Chase C · Port Lavaca, TXN367ZKrs Air & Cattle LLC · Durham, CAN3680Embry Tonya M · Sherman, TXN36800Fly Aviation Corp · Wilmington, DEN36802United States Air Force- Owner · Hanscom Afb, MAN36804Poplar Grove Airmotive Inc · Poplar Grove, ILN3680CBindon Phil E · Wasilla, AKFirst renewal noticeN3680RYatra Global LLC · Bedford, MAN3680UMoughon Kirby W · Melbourne, FLN3680WBeachy Titus E · Altamont, TNN3680ZDriskell James P · Anchorage, AKN3681DGcsw Holdings Inc · Poplar Grove, ILN3681GRed Wolf Aviation LLC · Wilmington, DEN3681NCange Shawn · Anchorage, AKN3681RSood Manu · Southfield, MIN3681YJeff Blue Corp · Seminole, FLN3681ZDickson Robert T · Charlotte, NCN36829Prime Aviation LLC · Wilmington, DEN3682CKiger Lance B · Prairieville, LAN3682DLasseter Granville D II · Richmond, TXN3682PDaily John F · Chugiak, AKN3682RTaylor John Edw · Alvarado, TX
Back to AD 2007-04-19 R1