Registered aircraft · 40,472

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-04-03-R2') 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-04-03-R2') 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-04-03-R2')
    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-04-03-R2')
  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-04-03-R2')
  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-04-03-R2')
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.

N318MAHigh Plains Aviation LLC · Nara Visa, NMBuilt 2001 · S/N 2178 N318PABird Acquisition LLC · Phoenix, AZBuilt 2002 · S/N 4496134 N318PWN318pw LLC · New Canaan, CTBuilt 1973 · S/N 17262171 N318RALouden Bruce H · Kalispell, MTFirst renewal noticeBuilt 1977 · S/N 13048 N318RCLafrance Lon H · Rocky Mount, MOBuilt 1977 · S/N 17269183 N318VFShramek Troy A · Bossier City, LABuilt 1973 · S/N 17702008 N31900Woodward Joseph A Jr · Wshngtn Xing, PABuilt 1978 · S/N 28-7816592 N31905Weishuhn Aviation LLC · Farwell, MIBuilt 1978 · S/N 28-7890484 N3191PStone Clifford F Jr · Corning, CABuilt 1957 · S/N 23-1129 N31923Metro Aicraft Co · Bloomington, MNBuilt 1978 · S/N 28-7816597 N31926Van Cura Don · Chicago, ILBuilt 1978 · S/N 28-7890486 N3192THawley James W · Waddell, AZBuilt 1967 · S/N 17700492 N3195ZMcgrady Chadwick Paxton · Glade Park, COBuilt 1959 · S/N 18-7191 N31969Chandelle Flying Club Inc. · Austin, TXBuilt 1978 · S/N 28-7890488 N3196TNicholson Perry R · Merlin, ORBuilt 1968 · S/N 17700496 N3197TMundle Jeffrey A · Ashland, ORBuilt 1967 · S/N 17700497 N3197ZSlayden Steven M · Rhome, TXBuilt 1959 · S/N 18-7195 N31985Ledge Aero Inc · Holt, MIBuilt 1978 · S/N 28-7816604 N31988Little Dog Aviation LLC · Branchburg, NJBuilt 1978 · S/N 28-7816605 N3198FDepinet Rodney J · Glen Saint Mary, FLBuilt 1968 · S/N 17256588 N3199TMortgage Experts LLC · Homestead, FLBuilt 1967 · S/N 17700499 N319ECRansom Robert W · Moorestown, NJBuilt 1994 · S/N 19032C N319FTPerez Guillermo T · Castaic, CABuilt 1982 · S/N 28-8216208 N319GRGuinn John F · Baxter, TNBuilt 1978 · S/N M-2080 N319HNorthbound Leasing And Sales LLC · Anchorage, AKBuilt 1999 · S/N 193 N319JPElon Aviation LLC · Burlington, NCBuilt 1973 · S/N 17262752 N31ACTango Thirty Aero Clube Inc · Mckinney, TXS/N 17261643 N31AGStaffenhagen Anthony J · Eden Prairie, MNBuilt 1977 · S/N AG-3 N31BDMaisler Brian D · Rosamond, CABuilt 1983 · S/N 354 N31BJAvco Patrol LLC · Lyndon, KSBuilt 1976 · S/N 17702489 N31BTMiddle Georgia Aviation Inc · Cochran, GABuilt 1960 · S/N 22-7447 N31CNSkyland Aviation LLC · Alpine, CABuilt 1976 · S/N 17267936 N31DMLejeune David E · Lake Charles, LABuilt 1977 · S/N 20-1248 N31FNUnlimited Aviation LLC · Lewes, DEBuilt 1999 · S/N 1222 N31GBMiller Bryan · Palisade, COS/N 0844-1 N31GGSchwend Brian · Forsyth, MTBuilt 1964 · S/N 2683 N31HJAero Tech Academy Inc · Redlands, CANon-citizen corporation, flight hours not reportedBuilt 1986 · S/N 0615 N31HYTaylor Edward S · Billings, MTBuilt 2003 · S/N 2244 N31JBLucian Aviation LLC · Modesto, CAS/N 17273002 N31JPOstmeyer John M · Gardner, KSBuilt 1956 · S/N 22-3913 N31KFSnow Terry R · Oak Harbor, WABuilt 2000 · S/N 607E N31LDGustte Phil · North Fort Myers, FLBuilt 1973 · S/N 17262736 N31LHUp And Up Aviation LLC · Magnolia, TXBuilt 1977 · S/N 28-7816236 N31LLNeidert Melvin E · Ulysses, KSBuilt 1993 · S/N MII 1239 N31MAlley Shane C · Jackson, MOS/N 188 N31PCFlight World Inc · San Juan, PRBuilt 1958 · S/N 23-1349 N31PPPlyler Aviation Lp · Sherman, TXBuilt 1969 · S/N PP-1 N31RBTigre Ecossais Aviation Inc Trustee · Wilmington, DEBuilt 1975 · S/N AA5B-0156 N31RWSpot Air LLC · Burlington, TXBuilt 1977 · S/N 17268693 N31SN31s LLC · Wadsworth, OHBuilt 1971 · S/N 28-7205080

Back to AD 80-04-03 R2