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.
N512LEHelipl LLC · Winter Garden, FLN512MACurrie George H III · Fleming Island, FLN512MSTiralongo Sebastiano · Weston, FLN512NDCoast Flight Training And Management Inc · San Diego, CAN512PTHigh Performance Aircraft LLC · El Cajon, CAN512RHHolloway Harry T (Tal) · Pittsboro, NCN512RSRollison Michael W · Fairfield, PAN512RTBas Part Sales LLC · Greeley, CON512SInternational Air Services Inc Trustee · Carson City, NVN512SBN512sb LLC · Austin, TXN512SLSalmon Raymond A Trustee · Tavares, FLN512SPAvolant Aviation LLC · Mooresville, NCN512TFN408dm LLC · Rye, NYN512TMSouthern Flight Aviation LLC · Bainbridge, GAN512TRFox And James Inc · Latrobe, PAN512TWDelaware Aircraft Trust LLC Trustee · New Castle, DEN512VAAb Prop Plane I LLC · Metairie, LAN512WMcm Sports LLC · Hailey, IDN512WYBrown Malcom · Bedford, WYN5130AAll Florida Aviation Inc · West Palm Beach, FLN5130EAviation Capital Management LLC · San Jose, CAN5130FC & M Dreamflights LLC · Mount Pleasant, SCN5130HCalkins David Martin · Anchorage, AKN5130LSalisbury Gershom · Prescott, AZN5130PWhite Guy B · Waxahachie, TXN5130RShamp Jimmy L · Fresno, CAN5130TInfinity Aviation LLC · Piedmont, SDN5130WMccutcheon Ernest Thomas · Ninety Six, SCN5130XHofferth Brian K · Anacortes, WAN5130YMerritt LLC · Leesburg, VAN5131Registered aircraftN51313Echo Tango 03 LLC · Anthem, AZN5131EBrunken Barry D · Tower Hill, ILN5131LSkipper Up LLC · Herron, MIN5131NPiedmont Aircraft LLC · North Myrtle Beach, SCN5131QLeavitt Craig S · Spicewood, TXN5131RMlt Operations LLC · Traverse City, MIN5131SForan Dana Francis · Bement, ILN5131T3b'S Land Development LLC · Seattle, WAN5131VBuswell Aviation Inc · Salem, ORN5131WArias Timothy R · Tempe, AZN5131XWilson Brent S Trustee · Dyer, NVN51325Baldwin Gordon Lee Jr · Altamonte Springs, FLN5132EFicklin Thomas L · Fairbury, ILN5132HMohnacs Joseph T · Mount Laurel, NJN5132LMongare Job · Athens, TXN5132PMccormick Geoffrey D · Goodyear, AZN5132QHauptman Ben · Alexandria, VAN5132RChristiansen Aviation LLC · Wilmington, DEN5132SFightin Fourth Line Pilots LLC · Gig Harbor, WA
Back to AD 2007-04-19 R1