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.
N6907NHensley Tyler · Leland, NCN6907VPounds Gregory S · Sykesville, MDN6908UPaul Michael · Fort Worth, TXN6908VForoozesh Paymon Michael · Olalla, WAN6909NDevore John A C · Marion, OHN6909UVandivort Austin J · Strawberry Plains, TNN690SHCorriher Mark B · Mocksville, NCN690TSMartin Tony A · Kingwood, TXN69104Giger Janice F · Weston, ORN6910NThornton Michael W · Clinton, NCN6910VLehman Aubrey M · Temple, TXN69110Zumbrun Dennis · Montz, LAN6911HHarbour Aviation LLC · Weatherford, TXN69121Everett Rylan C · Broken Bow, NEN69125Pine Hill Holdings LLC · Richmond, VAN6913NJennings William A · North Little Rock, ARN69142Registration Pending · Prescott Valley, AZRegistration pendingN69149Joyner Carol M · Claremont, CAN6914VDuke Terri D · Oakwood, GAN69156Lehman Alexander D · Sanford, NCN6915H2gbs LLC · Wilder, IDN6915NBaker Stewart D · Severna Park, MDN6915VReindollar William Paul Jr · Derwood, MDN6916HFms Air LLC · Leesville, LAN6916NGray Wesley K · Sandia, TXN69173Brs Leasing Inc · Wilmington, DEN6917NBonak Steven · Punta Gorda, FLN6917VCamper Daniel P II · Port Angeles, WAN69187Green Airports Development Corp · Kemah, TXN69189Lehman David G · Kent, WAN6918HWright Flight Inc · Tucson, AZN6918NBas Part Sales LLC · Greeley, CON6919HTimmester Terry W · Little River, SCN6919NNicholas Dagmar H · Uniontown, OHN6919VKimzey Robert R · Cypress, TXN691DBRvrh Ventures LLC · San Antonio, FLN691WEagle Simulator LLC · Lake Oswego, ORN69200Propel Air LLC · Pottstown, PAN69204Fca Flight Center Inc · Fitchburg, MAN69205Oklahoma State University · Stillwater, OKN69207Horman Richard Scott · Las Vegas, NVN6920CKiesel James L · Hanford, CAN6920NHodgman Gary W · Greenville, TXN6920VPjs Enterprises · Havre, MTN69212Briner Micah E · Martinsville, INN69213Weedhopper Aviation LLC · Sparks, NVN6921NBower Edwin M · Norco, CAN6921VLebow Kirk · Clovis, NMN69228Wings Over Texas Holdings LLC · Denton, TXN6922NPetrie Chris · Titusville, FL
Back to AD 80-25-07 R1