AD 80-25-07 R1
Registered aircraft · 25,368
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.
N1001JBowmar Bruce C · Oxnard, CAN1001MRocky Mountain Ventures Inc · Cheyenne, WYN1002MSchuler Mark E · Columbia, ILN1003AOakshire Aviation LLC · Yakima, WAN1003FChyatte Douglas · Saint Joseph, MON1004MReid Brian · Boise, IDN1005ESemaska Victor J · Kensington, CTN1006ESpot-Air LLC · Burlington, TXN1006UFike Brian Arthur · Florissant, CON1006WFadem Justin Andrew · Williamsville, NYN10074Linder Matthew L · Kalkaska, MIN1007NNewberg Edgar T · Hector, MNN1008CBat Flying LLC · Blue Earth, MNN1008EEdwards Gregory S · Guthrie, OKN1008LWilson Jeffrey M · Upper Arlington, OHN1008MHottenstein William R · Kingston, PAN1009CFord Richard B · Hendersonville, NCN1009EAven Michael D · Georgetown, INN100BVHoward Keith · Fayetteville, NCN100CGGreene Carol W · Mahwah, NJN100DBState Of Wisconsin · Madison, WIN100DPEskind Thomas O Jr · Dallas, TXN100GLWaco Aircraft Corp · Battle Creek, MIN100LDPenning Jeffrey D · Clear Lake, IAN100MSky Odyssey Aviation LLC · Gulf Breeze, FLN100NYAplustill Keith A · Los Osos, CAN100QBShutt Ryan T · Eden, NYN100RKEllingson Leslie B · Harwood, NDN100TEBlaney Robert L · Newark, OHN100YVPalmy LLC · Lander, WYN1010ARussell Jerald Trustee · Pampa, TXN1010GHyde Kinder · Montgomery, ALN1010QBurklund Joel H · Minneapolis, MNN1010RKaneair LLC · Hayes, VAN1011Martin Rex L Trustee · Bakersfield, CAN1011NBlue Skies Aircraft LLC · Zephyrhills, FLN1011TPedersen Michael · Bakersfield, CAN1013EFouts Chester L · Turner, MTN1013USiry Stanley A · Burke, VAN10143Fatdog LLC · Voorhees, NJN1014EMeade Lance M · Stinson Beach, CAN1014FPeppard Kenneth W · Dumfries, VAN1014TInternational Air Services Inc Trustee · Carson City, NVN1014UStubblefield Daniel R · Lake Havasu City, AZN1015SJacobs Forest R · Vero Beach, FLN1016FFly Cadillac LLC · Tustin, MIN10171Fod Flyers LLC · Fort Dodge, IAN1017EButtanda Denise · Winchester, VAN1017FImwalle John N · Batavia, OHN1018CSotek LLC · Cheyenne, WY
Back to AD 80-25-07 R1