Registered aircraft · 25,364

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.

N1039BG & M Aviation LLC · Kokomo, INBuilt 1981 · S/N 24-1119 N1039GFountain Keith E · Jacksonville, NCBuilt 1979 · S/N 21063174 N1039KMorris Eric K · Strasburg, VAS/N 24-3110 N103ACKrueger Douglas K Trustee · Aurora, NEBuilt 1992 · S/N 362-92 N103ASHill Bryan Thomas · Page, AZBuilt 1979 · S/N R18200923 N103BCPalmer David M · Jacksonville, ORBuilt 2003 · S/N 448-2003 N103PTAvion Guy LLC · Baton Rouge, LABuilt 1975 · S/N 22-1252 N103UC426th Aero Squadron LLC · Cropwell, ALBuilt 1980 · S/N 15284243 N1040PShogren Dennis · Grand Terrace, CAS/N R18200368 N10410Clark George A · Worcester, MABuilt 1975 · S/N 17702321 N1041SN1041s LLC · Key West, FLBuilt 1977 · S/N 17268658 N10420Kinney Powell Mcvay · Coppell, TXBuilt 1975 · S/N 17702324 N1042EPerez Alexander · Palmer, AKBuilt 1977 · S/N 1207-77 N1042SPiper Cameron · Winchester, VABuilt 1977 · S/N 172-68662 N1043SAmerican Aviator LLC · Newark, DEBuilt 1977 · S/N 172-68679 N1043ZJones Property Services Inc · Pelham, ALBuilt 1982 · S/N 24-1337 N10446Schell Brothers II LLC · Rehoboth Beach, DEBuilt 1973 · S/N 172-62515 N1046ERisk Indemnification Professionals LLC · Boston, MABuilt 1977 · S/N 296-77 N1046UMetzel Peyton S · Libertyville, ILBuilt 1989 · S/N 24-3114 N1048CPalmer Gretchen · Knoxville, TNBuilt 1976 · S/N 1153-76 N1048EPaul John R · Boise, IDBuilt 1977 · S/N 343-77 N104ACRoss Stephen D · Greenfield, OHBuilt 1993 · S/N 363-93 N104AFNance David B · Quinton, VABuilt 1967 · S/N 17700238 N104BVSea Horse Sportfishing LLC · Clinton, NCBuilt 1998 · S/N 405-98 N104JWGobeli Michael T · East Lyme, CTBuilt 1992 · S/N 688-92 N104NPDv Aviation Inc · Brainerd, MNBuilt 1975 · S/N 17265021 N104PBMountain Flight LLC · Missoula, MTBuilt 1974 · S/N 20-0035 N104PDBaumann James R · Muskogee, OKBuilt 1973 · S/N 17261428 N104UCAspiring Aviators Aero Club · Winter Haven, FLS/N 15284673 N104WDHill Keith D · Kirby, ORBuilt 1979 · S/N P21000366 N1051EHartman William · Imperial, MOBuilt 1977 · S/N 608-77 N1051YChristophersen Hunter · Fairway, KSBuilt 1989 · S/N 24-3116 N1055ERed Aero LLC · Scottsdale, AZBuilt 1977 · S/N 1208-77 N1056EMorrow James V · Boise, IDBuilt 1977 · S/N 974-77 N1057FBoldflight LLC · Bargersville, INBuilt 1979 · S/N 17272939 N105AAWehrmacher James P · Crawford, COBuilt 1978 · S/N R18200483 N105BHFran Oil Inc · Many, LABuilt 2007 · S/N 498-2007 N105JKSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N 17275306 N105PDN105pd LLC · Ulysses, KSBuilt 1973 · S/N 17261469 N105UCStem Aviation Academy · Carlsbad, CABuilt 1985 · S/N 15285998 N1061ENeal Foster Trucking Inc · Woodland, CABuilt 1977 · S/N 975-77 N1061XMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 172-69458 N1064UHenline Aircraft Sales LLC · Hickory, NCBuilt 1993 · S/N 24-3295 N1065NEmmons James W · Bay Minette, ALBuilt 1993 · S/N 24-3296 N1065XRobert C Ripley Mdpc · Nashville, TNBuilt 1993 · S/N 24-3299 N1067FNorklun Matthew J · Wainscott, NYS/N 24-3125 N1067GKmeck Joseph J · Erie, COBuilt 1990 · S/N 24-3174 N1067WGraham James M · Minneapolis, MNBuilt 1998 · S/N 24-3415 N1068AWest Texas Aviation LLC · San Angelo, TXBuilt 1989 · S/N 24-3133 N1068EHafford Jay T · Stevenson, WAS/N 253-77

Back to AD 80-25-07 R1