AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N9706XEl Paso Aero Inc · El Paso, TXN97071Heckathorn Chad W Trustee · Elk Point, SDN97073Rodland Karin D · New Concord, OHN97075Sopwith Camel Flying Club LLC · Salt Lake City, UTN97077Trail-Guides LLC · Sharpsburg, GAN9707GBurns Patrick · Carnation, WAN97082N97082 LLC · Scottsdale, AZN97084Dockall Jesse A · Litchfield Park, AZN97087Alpha Bravo LLC · Egan, LAN9708ABlack Mountains Air LLC · Madison, INN9708BBaxter Christopher V · Anchorage, AKN9708GDma Enterprises LLC · Fort Worth, TXN97096Lacy Clay · Groveland, CAN97097Youngman David A · Boca Raton, FLN97099Northwoods Air LLC · Orono, MEN9709AMckibbon Paul Lee · Millsap, TXN9709BPeterson Air LLC · Chisago City, MNN970CPCivil Air Patrol · Maxwell Afb, ALN970LTUniversity Of La System DBA · Ruston, LAN970MRGlobal Aviation LLC · Grain Valley, MON970RBBas Part Sales LLC · Greeley, CON9710ASky Mobility LLC · Warrington, PAN9710BWellnitz Patrick · Whitewater, WIN9710FAtp Aircraft 4 LLC · Wilmington, DEN9710GThompson William G · Mattawa, WAN9710TTrzynka Dean A · Iron River, WIN97116N97116 LLC · Hector, MNN9711AJones Stanley A · Benkelman, NEN9711GBurcham Robert A · Anchorage, AKN9711ZRed Leasing LLC · Juneau, AKN97123Peak Investments LLC · Roanoke, VAN97127Sandquist Michael A · Molalla, ORN9712BLafleur Kerry P · Fort Worth, TXN9712GReynolds Frederick A · Pilot Point, AKN97133Niner 7133 LLC · Layton, UTN9713ARueckl Randall L · Hortonville, WIN9713FDhs Operations LLC · Wilmington, DEN9713GKochert Timothy B · Anchorage, AKN97146Silver City Aviation LLC · Sterling, KSN97148Cullen Kevin · Bethesda, MDN9714AReinoehl Gregg A · Reelsville, INN9714XEtheredge William T IV · Texas City, TXN97154Poddoubnyi Andrey Alexandrovich · Vista, CAN97156Skaglin Michael S · White Lake, MIN97157Oliver Blake H · Talbotton, GAN97159Quetzal Aviation Corp · Washington, DCN9715AGarry L Lewis · Livingston, LAN9715FPlock Cory J · Southbury, CTN9715GMonfore Mark A · Wasilla, AKN97160Foster Mark C Trustee · Carson City, NV
Back to AD 79-10-14 R1