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

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

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.

N70141Priewe Flying Service LLC · Como, MSBuilt 1974 · S/N 18801847T N7014VAshland Cycle Center Inc · Catlettsburg, KYBuilt 1976 · S/N 22-1366 N7015GDaugherty William A · Horseheads, NYBuilt 1969 · S/N 17258715 N7016VHotel Charlie Aero LLC · Marshville, NCBuilt 1976 · S/N 22-1368 N7017QClair Michael A · Omaha, TXFirst renewal noticeBuilt 1971 · S/N 17260317 N7017VHenry R Rey Ltd · Fresh Meadows, NYS/N 22-1369 N7018GCape Aerial Tours Inc · Chatham, MABuilt 1969 · S/N 17258718 N7018QStockett & Assoc Ltd · Hattiesburg, MSBuilt 1971 · S/N 17260318 N7018VHausser Joel S · Greeneville, TNBuilt 1976 · S/N 22-1370 N70196South Shore Flying Club Inc · South Weymouth, MABuilt 1976 · S/N 17267195 N7019QYenser Thomas A · Kutztown, PABuilt 1971 · S/N 17260319 N7019VA & L Aviation LLC · Little Falls, MNBuilt 1976 · S/N 22-1371 N701BPWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17270604 N701EPErpco LLC · Wilmington, DEBuilt 2024 · S/N 640-2024 N701HGGeorgia Aviation Authority · Eastman, GABuilt 1997 · S/N 1365-97 N701MDDel Mar Aviation LLC · Algona, IABuilt 1980 · S/N 21064007 N701PYVallala Dino D · Milton, WABuilt 1978 · S/N 17270811 N701SDRescue Ministry Corp · Haines City, FLBuilt 1980 · S/N R18201548 N7020QAufderheide Flying Service Inc · De Witt, ARBuilt 1971 · S/N 17260320 N7020VHarris Robert W · Friendswood, TXBuilt 1976 · S/N 22-1372 N70220Perun Av LLC · Cliffside Park, NJBuilt 1976 · S/N 17267196 N70225Southeast Flight Leasing LLC · Cumming, GABuilt 1976 · S/N 17267197 N70228Eagle Sky Patrol Inc · Deadwood, SDBuilt 1976 · S/N 17267198 N7022QChant Savanah B · Baggs, WYBuilt 1971 · S/N 17260322 N7022VCjsm LLC · Winter Haven, FLBuilt 1976 · S/N 20-1198 N70231Low Level Aero LLC · Myakka City, FLBuilt 1974 · S/N 18801873T N7023VJackson William G · Clinton, MDBuilt 1976 · S/N 20-1199 N7024QWells Nathan S · Scotia, NEBuilt 1971 · S/N 17260324 N70256Winn Edwin F · Louisville, KYBuilt 1976 · S/N 17267199 N7026VClear Ayr LLC · Texarkana, TXBuilt 1976 · S/N 22-1373 N7027QAero B Flying Service · Richards, MOBuilt 1971 · S/N 17260327 N7027VJohnson Marvin D · Gilbert, AZBuilt 1976 · S/N 22-1374 N7028Registered aircraftBuilt 1976 · S/N 22-1375 N70288Dakota Aircare Inc · Wagner, SDBuilt 1974 · S/N 18801879T N7028GKathol Donavin J · Hartington, NEBuilt 1969 · S/N 17258728 N7028QBurns Michael S · Coplay, PABuilt 1971 · S/N 17260328 N7029VGochee Peter A · Kansas City, MOBuilt 1976 · S/N 22-1376 N702BSTwo Bravo Sierra LLC · Auburn, CABuilt 2004 · S/N 1369-2004 N702DEKelly William G · Cape May Ct House, NJFirst renewal noticeS/N 17276522 N702GTsiouklas Aviation Inc · Dunedin, FLBuilt 1968 · S/N 17256919 N702MGAmerican Champion Aircraft Corp · Rochester, WIS/N 1236-2026 N702NVAca Sd LLC · Kalispell, MTBuilt 2017 · S/N 1171-2017 N702SDVaughn Gregory T · Santa Fe, TXS/N R18200293 N70323Sky Equity LLC · Woodbury, MNBuilt 1976 · S/N 17267200 N70326Triple E Farms LLC · Peculiar, MOBuilt 1974 · S/N 18801887T N70340Wings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267203 N7034GFat Tyre Flyers LLC · Moses Lake, WABuilt 1969 · S/N 17258734 N7034QTesch David P · Pardeeville, WIBuilt 1971 · S/N 17260334 N7034VBixler Adam D · New Prague, MNBuilt 1976 · S/N 22-1381 N70350Bigwings Ag Inc · Delavan, MNS/N 18801895T

Back to AD 80-25-07 R1