Skip to content

Registered aircraft · 40,471

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.

N9352JDiorio Robert A · Redlands, CABuilt 1966 · S/N 28-3450 N9353DRegistration Pending · Simi Valley, CARegistration pending, canceledBuilt 1982 · S/N 172RG1131 N9353JNychka Robert J · Wills Point, TXBuilt 1966 · S/N 28-3451 N9353VLangholz Denise M · Covington, WABuilt 1969 · S/N 700011 N9354JLamb David S · Yuba City, CABuilt 1966 · S/N 28-3453 N9354SLinda Ann Trust LLC · Dover, DES/N M-1654 N9354VPinckney Robert L · Elgin, SCBuilt 1969 · S/N 700009 N9355DHarris Chet A · Anchorage, AKS/N 18-6616 N9355SBestway Pilot Car LLC DBA · Metropolis, ILBuilt 1975 · S/N M-1656 N9356DHammond Dwight L · Burns, ORS/N 18-6617 N9356HQuad Cities Aero LLC · Bettendorf, IABuilt 1975 · S/N 17266113 N9356JVali Air Service LLC · Livingston, MTBuilt 1966 · S/N 28-3455 N9356SHeman Christopher M · Lees Summit, MOBuilt 1975 · S/N M-1657 N9357DLeary Patrick W DBA · Lewistown, MTBuilt 1958 · S/N 18-6618 N9357JKirchoff Jennifer L · Hamden, CTBuilt 1966 · S/N 28-3456 N9357VWise Christopher J · Plano, TXBuilt 1969 · S/N 700013 N9358CMiloud Chadd K · Fort Worth, TXBuilt 1978 · S/N 28-7816466 N9358ELechmanski Philip J · Shelter Island, NYBuilt 1979 · S/N 17272236 N9358LUnited States Air Force · Eglin Afb, FLBuilt 1986 · S/N 17276546 N9358SAnderson Justin T · Franklin, OHBuilt 1975 · S/N M-1658 N9359DFejes James Michael Jr · Anchorage, AKBuilt 1958 · S/N 18-6620 N9359HWarren Flying Club · Troy, MIBuilt 1975 · S/N 17266115 N935CWIn Flight Aircraft LLC · Howell, MIBuilt 2005 · S/N 4496213 N935DELong Island Aviators LLC · Seaford, NYBuilt 1978 · S/N 28-7990146 N935ERChristiansen Aviation LLC · Wilmington, DEBuilt 2005 · S/N 4496195 N935KMBeachy Philip R · Bonners Ferry, IDBuilt 2019 · S/N JA1703105 N935PTTailspin Tommys Inc · Port Townsend, WABuilt 1974 · S/N 17263040 N9360CPure Joy Aviation One LLC · Schaumburg, ILBuilt 1978 · S/N 28-7890401 N9360SWitt Dan W · Lancaster, SCS/N M-1659 N9360VHarvey John S · Garland, TXBuilt 1970 · S/N 700070 N9361SAviation Services LLC · Oshkosh, WIBuilt 1975 · S/N M-1660 N9361VDanson Corp · Henderson, NVBuilt 1969 · S/N 700015 N9362JSandy Bottom LLC · Nantucket, MABuilt 1966 · S/N 28-3461 N9364DSimmons John E · Anchorage, AKBuilt 1958 · S/N 18-6628 N9364JBerthiaume Richard R · Millbury, MAS/N 28-3463 N9365HAugusta Aviation Inc · Agusta, GABuilt 1975 · S/N 17266118 N9365JTrujillo Mark A · Corvallis, ORBuilt 1966 · S/N 28-3464 N9365KSchlecht Erich T · Pasadena, CABuilt 1976 · S/N 28-7625177 N9365PHolly Gerald C Jr · Soldotna, AKBuilt 1980 · S/N 18-8109013 N9366DLongboard Energy LLC · Broken Arrow, OKBuilt 1960 · S/N 18-6630 N9366HPowell Jonathan L · Violet Hill, ARS/N 17266119 N9366JDnr Aircraft LLC · Mesa, AZBuilt 1966 · S/N 28-3465 N9367HDeralex Airways LLC · Miami, FLBuilt 1975 · S/N 17266120 N9368DMiller Jonathan L · Anchorage, AKBuilt 1958 · S/N 18-6633 N9368JPierce Cale G · Fort Walton Beach, FLBuilt 1966 · S/N 28-3467 N9369DHackett Joel W · Georgetown, DEBuilt 1958 · S/N 18-6634 N9369JIcarus And Son LLC · Wilmington, DEBuilt 1966 · S/N 28-3468 N936AZN936az LLC · Miami, FLBuilt 1979 · S/N 17272075 N936PRD & D Air Inc · Dover, DEBuilt 1998 · S/N 60057 N936RJBullion Richard G · Louisville, COBuilt 2001 · S/N 21465

Back to AD 80-04-03 R2