AD 80-25-07 R1
Registered aircraft · 25,369
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.
N85CSeay Edward A · Signal Mountain, TNN85FASilver Express Co DBA · Miami, FLN85GLAviation Insurance Managers Inc · Uniontown, OHN85GPRay Hardee · Dupont, WAN85JAFrequency Change Aviation Services Inc · Nashville, TNN85JWWhittington Robert W · Blackwell, OKN85MLEscott Aerial Spraying LLC · El Reno, OKN85NPSamayoa Rodolfo T · San Dimas, CAN8601Lewis Richard F · Halifax, VAN8602VSchumaker Daniel J · Glenville, MNN8605VGibney Ricky D · Fargo, NDN8608VBenter Neil W · Ambrose, NDN8609VRegistration Pending · Frontenac, MNRegistration pendingN860BCJacobs Hunter L · Hood River, ORN860DCHarrison John Kevin · Durham, NCN860PARe Elite Aviation LLC · Hialeah, FLN8611VAlbright Harold R · Dubois, WYN8613VBoley Trevor T · Palmer, AKN8615VCitabria N8615v LLC · Westminster, CON8616VPittman Michael · Goodridge, MNN8619VPlane Folks LLC · Tucson, AZN861ACGuglietta Glenn W · Payson, AZN861PMFlying Luvbug LLC · Grafton, WIN8622VHoneycutt Aviation Inc · Olivehurst, CAN8624VMccoard Paul · Provo, UTN8625VLemaire Jonathan D · Taunton, MAN8626VAlaska Star Flying Club LLC · Wasilla, AKN8627VDunleavy John R · Mandeville, LAN8628VKemp Charles D · Fredericksburg, TXN8629VHorvath Stephen L · Lake City, MIN862ACMadelaire LLC · Bow, NHN862HLWilliams Michael D · Midlothian, TXN862TWTailwinds LLC · Ewing, NJN8631VBeving Charles J · Garden City, SDN8632VLindgren Steven D · Holyoke, CON8633VDe Rouchey Louis E · Yreka, CAN8634VKoykka Kevin P · North Wildwood, NJN8637VSmith Bruce W · Durango, CON8638VMonberg Robert M · North Pole, AKN863BCHoover Amy DBA · Donnelly, IDN863TAKeating Scott G · Ormond Beach, FLN86407Donalds Flying Service Inc · Pantego, NCN8640VFlannery John J · Atkinson, NEN8641VRusyniak Anthony J · Syracuse, NYN8642DAmerican Aviation Inc · Tracy, CAN8643Gillespie Warren H · Hamilton, MTN8643VLuvara Christopher J · Santa Clara, CAN8644Agaliotis Paul E · San Martin, CAN86440Wilde Air Service-Huron LLC · Volga, SDN8644VSale Reported · Humboldt, IASale reported
Back to AD 80-25-07 R1