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.
N5EJJones Eric M · Southbridge, MAN5FNM J S Corp · Howe, INN5GAActon Steve · Reno, NVN5GHDowin Robert R · Doylestown, PAN5KDTexas Tailspin LLC · Amarillo, TXN5MDDunn Vincent K · Salem, ORN5PTMunson George R · Westhampton, MAN5RBBanasik Associates Inc · Columbus, OHN5RWToms Ronald C · Lena, LAN5SMBearss Gordon M · Topeka, KSN5TEBythway William M · Painesville, OHN5YXRed Arrow Aviation LLC · Santa Teresa, NMN5ZMDakota & Skyy LLC · Louisville, CON6000QInternational Air Services Inc Trustee · Carson City, NVN6001QCurry Gary · Everett, WAN6003QOsborn John W · Cimarron, KSN6004QSmith Aviation Inc · Wilmington, DEN6005QBittle Gary D · Bald Knob, ARN6006CUtah State University · Logan, UTN6006QLevie Jeffrey T · Mount Holly, NCN6007CAdler Jeffrey S Trustee · Westminster, CON6007QRegistration Pending · Tampa, FLRegistration pendingN6009QDelone Charles P · Sarasota, FLN600BCRitch Steve · Baker City, ORN600FSHome Free Aviation LLC · New Port Richey, FLN600GGNlh Aviation LLC · College Station, TXN600PCRudd Wayne · Basalt, CON600VVMindy Limited LLC · Muscatine, IAN600WLMoore Stan D · Amarillo, TXN6012QClassic Aircraft LLC · West Point, NEN6013CWestra Jacob John · Visalia, CAN6014CHangar 14 LLC · Spokane, WAN6016LAssociated Aircraft LLC · San Diego, CAN6016QAbrahem Bishoy · Bakersfield, CAN6018QWilson Reed · Arlington, VAN601PAMendenhall Michael L · Douglasville, GAN6020QN6020q LLC · Jensen Beach, FLN6021QR&L Aviation Inc · Philadelphia, PAN6022LIrving Donald J · Deland, FLN6025CKesler Neal Trustee · Wilmette, ILN6026CPflueger Michael W · Scottsdale, AZN6026QKosmata Charles C · Mcpherson, KSN6027CShough Mark E · Bemidji, MNN6027QBergh Robert P · Hammett, IDN6028QSky Partners LLC · Sylacauga, ALN6029QHill John T · Saint Augustine, FLN602HPStraight Up Aviation LLC · Columbus, MSN602JYN13303 LLC · Miami, FLN602ZCook Innovative Enterprises LLC · Missoula, MTN6031EHigh Exposure Inc · Wilmington, DE
Back to AD 80-25-07 R1