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.
N5655QJamil Mohammad Mahbub · Stockton, CAN5656EN2893e LLC · Reno, NVN5657MBrown Walter H · Oceanside, CAN5657QRegistration Pending · Phoenix, AZRegistration pendingN5659QKlempel Reuel David · Eltopia, WAN565MAM & M Aviation LLC · Memphis, TNN565TEcho Baravo LLC · Geneva, ILN565WWard Ann Marie · Seattle, WAN5660QIcarus Air LLC · Austin, TXN5661EMiller Gavin G · Hedgesville, WVN5662MLopez Michael E · Kountz, TXN5662QMarshall Adam S · Spokane, WAN5663QCullen Andrew W · Tennille, GAN5667QLove Phillip Love · Rib Mountain, WIN5668QKrzyszton Philip · Waumandee, WIN5669MNass Michael · Clinton, IAN5669QMills James A · Dearborn, MIN566BGN566bg LLC · Leesburg, VAN566QButte Aviation Inc · Butte, MTN5670QMiller Steven J · Fresno, TXN5673QBrown Maxwell · Palm Springs, CAN5674QPac Hollow Flyers LLC · Omaha, NEN5675QZeigler Matthew James · Fairfax Station, VAN5677QDeramus Doris L Executor · El Paso, TXN5678QAndersen Allen E · Sandy Valley, NVN5679QLambert John D · El Paso, TXN567BBBeers Suzanne M · Colorado Springs, CON567DEclipse Inc · Sharon Springs, KSN567KSKing Sky Flight Academy LLC · Lakeland, FLN567PCMateri Lori A · Upton, WYN5681CT Squared Aviation LLC · Glendale, AZN5681QSteixner Jessica M · Madison, TNN5682QNagel Mildred J · Akron, OHN5685CAms Aviation LLC · Fort Smith, ARN5686QBolton Nicolas · Murfreesboro, TNN5687QRegistered aircraftN5687USierra Tango LLC · Nashville, TNN5689KShoemaker Craig · Houston, TXN5689QReynolds Shawn E · Ventura, CAN568BCN28179 Inc · West Gilgo Beach, NYN56904N83993 LLC · Cherry Hill, NJN5691NStevens Alan L · Wrightstown, NJN56928Jurkiewicz Clifford · Pottstown, PAN5692QOpen Air Aviation LLC · Colorado Springs, CON5693QKaufman Ben · Liberty, UTN5695CAerial Avionics Inc · Modesto, CAN5695KKalorama Aircraft LLC · Lewes, DEN5695QBabb Douglas L · Telford, PAN5696QTrilogy Alliance Group LLC · Kearney, NEN5697ERedstone Arsenal Flying Activity · Redstone Arsenal, AL
Back to AD 80-25-07 R1