AD 80-25-07 R1
Registered aircraft · 25,370
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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.
N539BXin Han Aviation LLC · Atwater, CAN539JJChersky Brian A · Santa Maria, CAN539PBHumphrey Daryle C · Graford, TXN53BSAloft Technologies Inc · Maple Grove, MNN53CCPcb Air LLC · Wilmington, DEN53FBBiniewicz Frank B · Downers Grove, ILN53GLWaco Classic Aircraft Corp DBA · Battle Creek, MIN53JVan Way Dillion J · Lafayette, LAN53RHRoyal Blue Medical Inc · Hanceville, ALN53SELundquist Christopher E · Hillsborough, CAN53VCAbita Skies LLC · Robert, LAN54003Albuquerque Aviation Academy · Albuquerque, NMN5400HF & J Air LLC · Abbeville, SCN5400JErwa Mohamed E · Leander, TXN54011United States Air Force (Owner) · Dover Afb, DEN54012Carelli Alfred J · Ocala, FLN54015Northwoods Air LLC · Orono, MEN5401AHeadon Richard · Chino Hills, CAN5401HDms Leasing Company LLC · Las Vegas, NVN5402EOsprey Holding Company LLC · Foley, ALN5402RBarsto Aviation Inc · Wilmington, DEN54031Mlr Adventures Inc · Wilmington, DEN54036Missions Unlimited Of Oregon Inc DBA · Harrah, OKN5403HWings Over Texas Holdings LLC · Denton, TXN5403VL & R Consulting LLC · Las Vegas, NVN54041Bowen John E · Ocala, FLN54048Hodge Flight Services LLC · Pittsburgh, CAN54049Pittinger Mitchell J · Reisterstown, MDN5404BRichmor Aviation Inc · Hudson, NYN5404WBas Part Sales LLC · Greeley, CON5405BNatkat Aviation Services LLC · Finleyville, PAN5405MToozer Air LLC · Ormond Beach, FLN54067St Pete Aviation Services LLC · Saint Petersburg, FLN54073Center O Flying Club · Tumwater, WAN54079Christiansen Aviation LLC · Wilmington, DEN5408ECutbirth Henry R · Monahans, TXN5408HSchmidt Kelly D · Lake Elmo, MNN5408RRegistration Pending · Brookland, ARRegistration pendingN54093Kamenev Alexey · Hinsdale, ILN54094Mustang Sally Aviation LLC · Camden, SCN5409JKelley Aircraft LLC · Weyers Cave, VAN5409RMclane Tucker · Newton, MAN5409YLee Christopher · Katy, TXN540ACChristians Ricky P · Appleton, WIN540DYYeager Joseph H · Zionsville, INN54102Adriatic Holdings LLC · Cheyenne, WYN54108Lawson Troy · Kettle Falls, WAN54115Mang Aero Club Inc · Belleville, MIN5411AMarc Aircraft Holding LLC · Soldotna, AKN5411HEarth Grazer Inc · Homer Glen, IL
Back to AD 80-25-07 R1