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.
N6320RGehr Garner J · Eustis, FLN6321MCalifornia In Nice Inc · San Jose, CAN6321PXin Han Aviation LLC · Atwater, CAN6321QDonesky Orville B · Cleveland, TNN6321TTwo One Tango LLC · Waynesboro, PAN6322NThelander Edwin · Bristol, MEN6323NRay Raymond Heath · Louisville, KYN6324NSimmons Rita B · Saint George, MEN6324QTymoshenko Yuriy · Clearwater, FLN6324TRegistered aircraftN6325DCox Ronnie L · Whitesburg, GAN6326EKevin Formica Inc · Boca Raton, FLN6326FAirtime Holdings LLC · Charleston, SCN6326QMontpelier Gary L · Bushnell, FLN63273Hlavinka Terrance J · East Bernard, TXN63279P & H Air Inc · Overland Park, KSN6327QHarrod Tracey Lynn · Bedford, KYN6328CArnold Aviation & Thunder Mountain Express Inc · Cascade, IDN6328PSabath Kenneth J Trustee · Powell, WYN6328YKoehn Lacey · Van Horn, TXN6329QRegistration Pending · Zavalla, TXRegistration pendingN6329YDiablo Aviation LLC · Pleasanton, CAN632KMouzakis Shaun Kevin II · Johnstown, CON6330CLos Angeles County Sheriffs Department · Long Beach, CAN6330VLegacy Lsa LLC · Lubbock, TXN63312Civil Air Patrol Inc · Maxwell Afb, ALN6331NMartens Air Service LLC · North Platte, NEN6332DBlue River Aviation LLC · Wasilla, AKN6332T32 Tango Aviation LLC · Beaverton, ORN6333FMattuski Joseph C Jr · Parker, COFirst renewal noticeN6333QEgan Cherlye R · Ramona, CAN6334ARhodes Brandon L · Woodville, TXN6334MSundance Flying Club Inc · Palo Alto, CAN6334QJed-Aire Aviation LLC · Benson, MNN63352Carter Flygare Inc · Sacramento, CAN6335QChandler Elijah J S · Pilot Mountain, NCN63366Purdue Aviation LLC · West Lafayette, INN6336QGeco Inc · Wilmington, DEN6336VKman LLC · Kalispell, MTN6337DHomerace Inc DBA · Tulsa, OKN6337QMariette Robert K · Happy Camp, CAN6337VFirelight Ventures LLC · Fuquay Varina, NCN6338FRaritan Valley Flying School · Princeton, NJN6338NCole Justin L · Mendon, NYN6338QTikhonov Andrey V · Chino, CAN6339CBowles Donald E Jr · Dallas, TXN6339DContrails II Inc · Kerrville, TXN6339MFlight World Inc · San Juan, PRN6339QVidoni Richard G · Hagerstown, MDN6339TRj Aircraft LLC · Vandling, PA
Back to AD 80-25-07 R1