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.
N5060LVassilou Dimitri · Berwyn, PAN5060MBowden James Jr · Fairbanks, AKN5060NNarveson Bryce J · Nerstrand, MNN5060UPeoples Douglas A · Horseshoe Bay, TXN5060XFour Guys Flying LLC · Tunica, MSN50615Stinger Tailwheel LLC · Miami, FLN50616Burge Kimberly · Wasilla, AKN50619Registered aircraftAssigned, pending cancellationN5061DKnight Frederick T · Arkadelphia, ARN5061GMoore David B · Wasilla, AKN5061KSchweiss Charles · Fairfax, MNN5061NGroth Matthew C · Arlington, WAN5061UColorado Northwestern Community College · Rangely, CON5062CSchiegner Kyle Glen · La Mesa, CAN5062DRoberge Guy C · Westborough, MAN5062GMore Right Rudder LLC · Menlo Park, CAN5062JDomack Christopher S · Toccoa, GAN5062KBennett George III · Lambertville, NJN5062LSundial Getaways LLC · Santa Rosa Beach, FLN5062NSmith Julia P · Bedford, WYN5062PPiercy Ronald S · Moses Lake, WAN5062RRichland County Finance Department · Columbia, SCN5062YDerossett Trevor · Manville, ILN50630Burnham William L · Lynchburg, VAN50636Placer Aviation LLC · Loomis, CAN5063DIndian Ridge Ag Enterprises LLC · Pavillion, WYN5063HParsons William L · Harrogate, TNN5063LVirga Aviation LLC · Virginia Beach, VAN5063WChampagne Patrick D · San Angelo, TXN5063XGrundy James W · West Greenwich, RIN5063YPlane Fun Inc Tr Trustee · Snellville, GAN5064GCurran Joseph R · Eielson Afb, AKN5064HFranklin Air Services LLC · New Orleans, LAN5064KShin Harry K Jr · Castro Valley, CAN5064URowe Timothy R · Texarkana, ARN5064XHuber Bryan L · Jonesboro, ARN5065KHahn Troy J · Troy, OHN5065NWest Valley Flying Club · Palo Alto, CAN5065XWallace Aviation Inc · Wallace, NEN5065ZFour Guys Flying LLC · Tunica, MSN5066GRuggles Arthur E · Andersonville, TNN5066KShiner Mach LLC · Kingwood, TXN5066LMeise Fred W · Moses Lake, WAN5066RBurke William M · Norwalk, CTN5066XChandelle LLC · Chelsea, ALN50678Nieslanik Diane M · Cokeville, WYN5067CMutter William D · Chelan, WAN5067GJones Jerry E · Pocahontas, ARN5067HSanders Flight Training Center Inc · Jasper, ALN5067KN5067k LLC · Lenexa, KS
Back to AD 80-25-07 R1