AD 2005-10-13
Registered aircraft · 1,224
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:2005-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-10-13')
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:2005-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-10-13') 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.
N450AGInternational Air Services Inc Trustee · Carson City, NVN450XPlane Enjoyment LLC · Dover, MAN451HAIron Horse Aviation LLC · Marshalltown, IAN451LEEnstrom Helicopter Corp · Menominee, MIN451NEEnstrom Helicopter Corp · Menominee, MIN451REEnstrom Helicopter Corp · Menominee, MIN452MCCitrus County Mosquito Control District · Lecanto, FLN454JHJack Harter Helicopters Inc · Lihue, HIN454MSCb Couch Inc · Walcott, ARN4569U S Army · Ft Rucker, ALN456KJTaod Aviation LLC · Elkhart, INN458HWHeliwild Investments LLC · Austin, TXN458PBBarbaro Paul G · Argyle, TXN463RARanger Aviation Leasing LLC · Wilmington, DEN467PHPhi Health LLC · Tempe, AZN46CLHelicopters Inc · Wilmington, DEN46DKWrong Bros Ranch LLC · Lake Havasu City, AZN46EEUnited States Department Of Agriculture · Cedar City, UTN472MRight Brother Aviation LLC · Chaffee, NYN473EOchoco Wood Products LLC · Prineville, ORN475ALScotts Helicopter Service Inc · Le Sueur, MNN478NWTmds Air Inc · Gig Harbor, WAN479DBAmerican Honor Foundation Inc · Ocala, FLN47HHJkt LLC · Douglas, WYN4806Tennessee Helicopter Sales & Service Inc · Bolivar, TNN480ABBardo Wade · Erin, NYN480AJRamos Aviation Services LLC · Arvada, CON480CJCentrix Air Inc · Central Point, ORN480DDButler William J II · Juntura, ORN480EMidtex Aviation LLC · Midlothian, TXN480EHSloflight LLC · Ogden, UTN480ENEnstrom Helicopter Corp · Menominee, MIN480FHFalcon Helicopters Inc · Logan, NMN480GBInternational Air Services Inc Trustee · Carson City, NVN480HCHangar Seven LLC · Penn Yan, NYN480JBSouthern Aircraft Consultancy Inc Trustee · Casper, WYN480JSRichard Smith Farms Inc · Rexburg, IDN480LIrrg LLC · Kane, PAN480MDJ&H Aicraft Leasing LLC · Berrien Springs, MIN480MHBank Of Utah Trustee · Salt Lake City, UTN480MLCline Air Services LLC · Ellensburg, WAN480MMAviation LLC · Madison, WIN480MTCline Air Services LLC · Ellensburg, WAN480PQPlaquemines Parish Sheriff'S Office · Belle Chasse, LAN480RSEuroaviation Inc Trustee · KematenN480THTroubleshooter Network Inc · Denver, CON480TRAdlr Heli Inc Owner Trustee · Wilmington, DEN480TTSanta Lucia Holding · Forked River, NJN480VPropwash LLC · Mesquite, NVN480VAFliege Jetzt LLC · Loveland, OH
Back to AD 2005-10-13