Skip to content

Registered aircraft · 5,102

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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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.

N234JFInternational Air Services Inc Trustee · Carson City, NVS/N 32R-7887265 N234MFGone Flying LLC · Salt Lake City, UTBuilt 2006 · S/N T18208492 N2365FBottorff Jon C · Fishers, INBuilt 1999 · S/N T20608102 N2365JBrosius Michael W · North Platte, NEBuilt 1999 · S/N T20608099 N2369WRoyal Kenneth L · Savannah, GABuilt 1985 · S/N 32R-8529014 N236CMWright Kim B · Anchorage, AKBuilt 1997 · S/N 27-0236 N2370XSouthwest Aircraft Enterprises · Haslet, TXBuilt 1999 · S/N T20608026 N2371HSan Jose Aviation LLC · Mission, TXBuilt 1999 · S/N T20608060 N23781Paragon Air Group · Fort Worth, TXBuilt 1999 · S/N T20608017 N2378XState Of Utah · Salt Lake City, UTBuilt 1999 · S/N T20608023 N2378YLindsey Aviation Services · Haslet, TXBuilt 1999 · S/N T20608025 N2379FWebster Douglas Clark · Las Vegas, NVBuilt 1999 · S/N T20608019 N237REDobbert Thomas · Reno, NVBuilt 2004 · S/N T18208299 N2381YInvictus Investments LLC · Urbandale, IABuilt 1999 · S/N T20608018 N2389GMacon Septic Systems Co Inc · Macon, MSBuilt 2006 · S/N T20608586 N2389LCjw Holdings LLC · Stamping Ground, KYBuilt 2000 · S/N T20608255 N2391EInnova Energy LLC · Wilmington, DEBuilt 1999 · S/N T20608115 N23BQCentral Airlines Inc · Overland Park, KSBuilt 1961 · S/N 500A-1065-46 N23LLAjca Farms LLC · Kalispell, MTBuilt 1975 · S/N 61-0252-100 N23MCFilm Fliers Inc · Orlando, FLBuilt 1976 · S/N 32R-7680190 N23MMAmerica Atlantic Aviation Inc · Stuart, FLBuilt 1967 · S/N 32-40367 N23WBQualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 27-7405281 N2400TAircraft Guaranty Corporation Trustee · Oklahoma City, OKBuilt 2000 · S/N T20608160 N2405MFree Flyers Avionics Inc · Kerkhoven, MNBuilt 1979 · S/N 27-7954049 N240JBMarking Kevin J · Omaha, NEBuilt 1978 · S/N 27-7854108 N2416MSun South Aviation LLC · Wilmington, DEBuilt 1977 · S/N 32R-7880063 N241GTBroshchan Ruslan A · Jackson, MSS/N 2141 N241KRMako Offshore Exploration Inc · Pagosa Springs, COBuilt 2004 · S/N T18208326 N241PBTranstek International Inc · Deerfield, ILBuilt 1964 · S/N 27-2589 N241WFInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 31-7852073 N2422UDennissan LLC · Noble, OKBuilt 1979 · S/N 32R-8029002 N242GG242gg LLC · Wilmington, DEBuilt 1979 · S/N 31-7952080 N242KFTio Pedro P · Miami, FLBuilt 2002 · S/N 3257277 N242RKBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 31-7512025 N242TC182 Flight Corp · Bronx, NYBuilt 2005 · S/N T20608530 N24301Pacific Coast Cycle Corp · Kings Beach, CABuilt 1999 · S/N T20608139 N24337Dunn Craig M · Sarasota, FLBuilt 2000 · S/N 18280713 N2433UEddleman David Baggett · Mclean, VABuilt 2001 · S/N T18208006 N243MCRankin John · Nokomis, FLBuilt 2004 · S/N T18208243 N243PSN9089 LLC · Lewes, DES/N 3257073 N2440PN2440p LLC · Seattle, WABuilt 1999 · S/N T20608136 N2440VVehrs Roger K · Roseburg, ORBuilt 2000 · S/N T20608176 N2441GTognoli Stefano F · Union, ORBuilt 2000 · S/N T20608173 N2441MBlackburn Alan Ryan II · Palm City, FLBuilt 1979 · S/N 27-7954059 N2441YTag Aviation LLC · Santa Teresa, NMBuilt 2000 · S/N T20608169 N2446ESugarloaf Air LLC · Wilmington, DES/N T20608580 N24480Moscair LLC · Nashville, TNBuilt 2001 · S/N 18280932 N244ACScruggs Ken · Galloway, OHBuilt 1968 · S/N 1815-21 N244MEEagle Forestry Services Inc · Monticello, ARS/N T20608192 N244RWeiser Inc · Minburn, IABuilt 1973 · S/N 27-7305025

Back to AD 81-12-06 R1