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.
N5617CRoot Griffin W · Fayetteville, GAN5617JSale Reported · Wilton, CASale reportedN5617PBuchheit Dirk · Lake Worth, FLN5617QRegistration Pending · Perryton, TXRegistration pendingN5617UManagement Company Of South Carolina LLC · West Columbia, SCN5617WRose Dean R · Appleton, WIN56180Gosney Don L · Bayfield, CON56182Gerst Peter C · Williamsport, PAN5618KLundin Michael D · Magnolia, DEN5618QHecker Clark R · Flat Rock, NCN5618SAnnable John W · Pls Vrds Pnsl, CAN56190Bertch Gary M · Waterloo, IAN56191Twedt Jeffrey Lee · Montrose, SDN56198Holden James R Jr · Milton, GAN5619ELiberty Flying Service LLC · Castroville, TXN5619KGood Natured Creations LLC · Tucson, AZN5619WIsbell David Myles · Tucson, AZN561ATSheets Jeff M · Salmon, IDN561BLPiper Aircraft Inc · Vero Beach, FLN561CDGainesville Aircraft Sales Inc · Gainesville, FLN561DAb Prop Plane II LLC · Metairie, LAN561DEFlynn John M · Martinez, CAN561FGRidgeline Assets LLC · Wilmington, DEN561FLOnwe Edward E · San Antonio, TXN561FSGummo Thomas L · Apple Valley, CAN561MAMcdonald Jeffrey D · Chilmark, MAN561MBVital Equipment LLC · Midland, TXN561MHDodson International Parts Inc · Rantoul, KSN561NDSpartan Education LLC · Tulsa, OKN561PWestern Farming LLC · Missoula, MTN561PUSkyborne Airline Academy Inc · Vero Beach, FLN561SAWingsleasing LLC · Wichita, KSN561SCSpartan Education LLC · Tulsa, OKN561SDAugspurger David R · Seneca, SCN561SPIllinois State Police · Springfield, ILN561TSierra Alpha Air LLC · Piqua, OHN561TFAir Fleet Holdings LLC · Missoula, MTN561TPKerner Christine A · Yelm, WAN561ZDelgado-Ocasio Brunilda · Patillas, PRN56201Kaney Howard W · West Bend, WIN56202Kunze Paul C · Tempe, AZN56204Andreas Charles V · Neenah, WIN5620BBend Aircraft Rentals LLC · Bend, ORN5620JPearce Gregory W · Eagle River, AKN5620QMorgan Josiah B · Owasso, OKN56211Bergstrom Aircraft Inc · Pasco, WAN5621BArtz James R · White Bird, IDFirst renewal noticeN5621QOwens Ronald W · Newburgh, INN5621UMeinert Kyle L · Cottage Grove, WIN5621WHurt Bret K · Huntsville, AL
Back to AD 2007-04-19 R1