AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N15TYArneson Kenneth W · Beaverton, ORN15USale Reported · Van Nuys, CASale reportedN15VRCarley Daniel · Center Moriches, NYN15WAG Force Aerobatics LLC · Eugene, ORN15WJFleming Laurence Erik · Salinas, CAN15YMMiller Jeff A · Deering, NHN15YPDepartamento De Educacion Prami · San Juan, PRN1600UOsprey Holding Company LLC · Foley, ALN16019Brown Kenneth D · Port Murray, NJN1601SRussell Bryan E · Joshua, TXN16021Hill Allen W · La Junta, CON16023Carr Richard D Trustee · Stockton, MON16066Thompson Derek D Jr · Dunkirk, MDN1608SNew Horizon Aviation Inc · Warwick, RIN160AASauerbrey Andreas M · Steamboat Springs, CON160BCPridmore Reginald C · Laughlin, NVN160CAPrice Keyth E · Ossian, INN160DPrice Paul L · Lancaster, VAN160DSSalcedo Daniel R · Fort Lauderdale, FLN160FUExtreme Attitude Recovery & Aerobatics LLC · Cincinnati, OHN160GMUsda-Aphis-Ws · Cedar City, UTN160JRRhinehart Gerald A Jr · Lordstown, OHN160KTDiscover Resources LLC · Norman, OKN160LMMino Leonard G · Pueblo West, CON160MAWells Scott A · Fort Myers, FLN160PTPilot Training Center LLC · Miami, FLN160WBBeach Banners Inc · Jacksonville, FLN160WWBrynelsen Charles R · North Oaks, MNN160XMalolo LLC · San Luis Obispo, CAN16134Adibi Saeed · Huntsville, ALN16137Hines Roger E · Greenville, OHN1614JCoraggio Joseph · Chandler, AZN1615AAnson Air LLC · Sugar Land, TXN16185Schwartz David W · Windsor, NYN16199Allbritton John Mark Trustee · Oakland, TNN161AMDe Boissard Karen · New York, NYN161BLAirborne Holdings Inc · Midlothian, TXN161BWWelch William Ben · Danville, ILN161CMR&J Helicopters LLC · Port Byron, ILN161DSHeffron Neuhold Nicholas A · Honolulu, HIN161FCAps Asset Management Inc · Mesa, AZN161GLEdwards Jeffrey L · Port Orange, FLN161JHAllison Daniel S Trustee · Jenner, CAN161JLLuebben John R · Fayetteville, GAN161LMays Stephen W · Carson City, NVN161MABarnes Gordon R · Manalapan, NJN161MRVictor Aircraft Co · Wilmington, DEN161MSBaker Weldon J · Lamesa, TXN161PRegistered aircraftN161PCSpence Jeffrey · Haskell, OK
Back to AD 2006-10-21