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.
N2958LStormo Jarrod M · Indianapolis, INN2958XCooper Ronald C · Fowlerville, MIN29592Reyner Matthew J · Georgetown, TXN29593Else John J · Toledo, IAN29595Delta Fox Corp · Schaumburg, ILN29596Murray Charles W · Reno, NVN2959LMcphillips Jess H · Port Arthur, TXN2959XCiochetti David · Kimberly, ORN295ACFanjoy James Michael · Nehalem, ORN29617Abbott Barry · Tempe, AZN29619Loudenslager Donald F · Collinsville, OKN2961JFrey Jerry P · Fallon, NVN2961XLaurina Peter · Knoxville, TNN29625Sale Reported · Fort Myers, FLSale reportedN2962EPaulisue Aviation LLC · East Saint Louis, ILN2962LAllen Marcus I · Little Elm, TXN2962XRomine John M · Broken Arrow, OKN2962ZMull Jason E · Chester, NYN2963XWayner Ronald P · Sutton, AKN29643Campbell Robert A · Dayton, TXN29645Borgman Dale A · Rescue, CAN29651Geurs John Z · Ossian, INN2965XLynch Thomas L · Fort Collins, CON29664Tyree William B · Arlington, TXN29667Viles Timothy · Bartlett, TNN2966LCarpenter Robert E · Huntsville, ALN29673Olson Andrew S · Copper Canyon, TXN2967EBme N2967e LLC · Clearwater, FLN2967GMcallister A J Trustee · Buford, GAN2967L2967lima LLC · Scott City, MON2968XJansen Edward M · Hummelstown, PAN2969LSeegers Matt J · Westlake Village, CAN296ACNewton Thomas L Jr · Fredericksburg, VAN296DDDouglass Darrell C · Jamestown, CAN2970ESparrowhawk Aviation · Manvel, TXN2970XMonroe William R · Hawk Point, MON2971LRegistered aircraftN2972LMorris Russell K · Cameron Park, CAN2973ZLandrum Erik G · Austin, TXN29742Payne David T · Monticello, ILN2974XAnderson Keith · Covington, TNN2975QWorker Timothy M · Fairbanks, AKN2975WFoldesi Dennis · Merritt Island, FLN29762Davis Evan A · Fairbanks, AKN29763Wilson Woodie J · Collins, MSN2976CGarrett John G · Conway, WAN2976LRichardson Samuel O · Villa Rica, GAN2976XPechota Steven F · Palmer, AKN2976ZEvans James · Millbrae, CAN29772Sublett John L · Georgetown, TX
Back to AD 80-25-07 R1