AD 2012-11-05
Registered aircraft · 305
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:2012-11-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-11-05')
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:2012-11-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-11-05') 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.
N454PCannon Travis H II · Corinth, TXN456KJTaod Aviation LLC · Elkhart, INN46DKWrong Bros Ranch LLC · Lake Havasu City, AZN4806Tennessee Helicopter Sales & Service Inc · Bolivar, TNN480ABBardo Wade · Erin, NYN480AJRamos Aviation Services LLC · Arvada, CON480BHagglund Carl D · Pendleton, ORN480CJCentrix Air Inc · Central Point, ORN480DDButler William J II · Juntura, ORN480EMidtex Aviation LLC · Midlothian, TXN480EHSloflight LLC · Ogden, UTN480ENEnstrom Helicopter Corp · Menominee, MIN480FHFalcon Helicopters Inc · Logan, NMN480FXMansfield Heliflight Inc · Milton, VTN480GBInternational 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, PAN480LRDouble Diamond Equipment LLC · Big Horn, WYN480MNew Course Aviation Co · Golden, CON480MDJ&H Aicraft Leasing LLC · Berrien Springs, MIN480MHBank Of Utah Trustee · Salt Lake City, UTN480MLCline Air Services LLC · Ellensburg, WAN480MMAviation LLC · Madison, WIN480MSHamm Equipment Inc · Casper, WYN480MTCline Air Services LLC · Ellensburg, WAN480PPHelo 1 LLC · Anchorage, AKN480PQPlaquemines Parish Sheriff'S Office · Belle Chasse, LAN480RSEuroaviation Inc Trustee · KematenN480SHCasciani LLC · Webster, NYN480THTroubleshooter Network Inc · Denver, CON480TRAdlr Heli Inc Owner Trustee · Wilmington, DEN480TTSanta Lucia Holding · Forked River, NJN480VPropwash LLC · Mesquite, NVN480VAFliege Jetzt LLC · Loveland, OHN480VCSn5084 Inc Trustee · Wilmington, DEN481SHRhoads Timothy C · Logan, NMN482MHDrd Aviation LLC · Park City, UTN483SHSharkeys Helicopter Inc · West Lebanon, NHN484MHNew Course Aviation Co · Golden, CON484TJSky High Leasing LLC · Montrose, CON48FSOwen Jay · Wolf Creek, MTN48NEnstrom Helicopter Corp · Menominee, MIN503PDWjt Investments LLC · Gurley, ALN50AZBenson Aviation LLC · Mehoopany, PAN50DRAdf Helicopters Inc · Brewster, WAN51659Hawk Robert S · Argyle, TXN51665Rotor-Lift LLC · Swartz Creek, MIN51693Borreson Anthony · Reno, NV
Back to AD 2012-11-05