Skip to content

Registered aircraft · 47,138

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:2000-23-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21') 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:2000-23-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
  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:2000-23-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
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.

N2085MVee Two Inc · Merritt Island, FLS/N 34-7870063 N2085SRichards John · Casa Grande, AZBuilt 1975 · S/N 21061051 N2085XBrian Murray J · Pekin, ILBuilt 1965 · S/N 18256185 N2085YLima Romeo Kilo Golf Lp · Worthington, INBuilt 1973 · S/N 18502151 N20862Barrington Aviation LLC · Kalamazoo, MIBuilt 1972 · S/N 18261267 N2086GHigh Country Aces LLC · Cove, ARBuilt 1958 · S/N 51386 N2086LMortensen Daniel R Trustee · Newhall, CABuilt 1976 · S/N CE-658 N2086XPerron Joseph R · Jasper, GABuilt 1965 · S/N 18256186 N20870Willis David A · Thief River Falls, MNBuilt 1972 · S/N 18261274 N20877Teton Leasing LLC · Pocatello, IDBuilt 1972 · S/N 18261279 N2087FH & M Ltd · Warren, IDS/N 18264886 N2087GTate Frederic H S DBA · Marfa, TXBuilt 1958 · S/N 51387 N2087L30 West Pilots LLC · Dover, DEBuilt 1976 · S/N TC-2007 N2087RMangus Ricky Alan · Kent, WABuilt 1964 · S/N 18255287 N20882Stuart Roger G Jr · Mount Pleasant, TXBuilt 1972 · S/N 18261283 N20888Baker Michael A · Watsonville, CABuilt 1972 · S/N 18261287 N2088CBeech K Holdings LLC · Sheridan, WYBuilt 1959 · S/N D-6044 N2088RRegistration Pending · Fort Worth, TXRegistration pendingBuilt 1964 · S/N 18255288 N2088USimpson Equipment Leasing LLC · Hays, KSBuilt 1982 · S/N U20606610 N20890Thomas Brett · Gettysburg, PABuilt 1972 · S/N 18261289 N20896Mccullar Miles Glenn · Hagerman, NMBuilt 1977 · S/N E-1163 N2089WBaron 2089w LLC · Jupiter, FLBuilt 1966 · S/N TE-60 N2089XMoravitz Kim J · Turtle Lake, WIBuilt 1965 · S/N 18256189 N208CDStec Corp · Wilmington, DEBuilt 2000 · S/N 1074 N208GTGti Properties LLC · Elyria, OHBuilt 2006 · S/N 1621 N208LGAnson Douglas M · Dripping Springs, TXBuilt 2005 · S/N 1566 N208LHOtt Grosvenor LLC · Dillingham, AKBuilt 1974 · S/N U20602642 N208PGrateful Center Transportation LLC · Lutz, FLBuilt 1991 · S/N TH-1626 N208QPetersen Robert Trustee · Harrodsburg, KYBuilt 1965 · S/N TC-898 N208SSSeldom Seen Aviation Northwest Inc · Stevensville, MTBuilt 1974 · S/N 18502452 N208TMustang Sally LLC · Bullhead City, AZFirst renewal noticeBuilt 1974 · S/N E-572 N208TCKissee Zachary Robert · Chugiak, AKBuilt 1976 · S/N 18052749 N208WPCassidy Ryan H · Seattle, WABuilt 1980 · S/N U20605836 N208WSMoore David P · Chugiak, AKBuilt 1969 · S/N NAV-4-2528 N20907Ward Roger L · Ghent, WVBuilt 1972 · S/N 18261345 N2090GLight Chop LLC · Lexington Park, MDBuilt 1958 · S/N 51390 N2090LBarnes Seth M · Hot Springs, ARS/N D-10074 N2090XTreeline Services LLC · Grimes, IAS/N 18256190 N20914Jackson George F Jr · Saint Leonard, MDBuilt 1972 · S/N 18261294 N2091LLippert John C · Danville, VABuilt 1976 · S/N E-967 N2091VAircraft Partners LLC · Owensboro, KYBuilt 1979 · S/N 28R-7931108 N2091XBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 18256191 N20920Berry Danny · Rusk, TXBuilt 1972 · S/N 18261295 N20923Langford Thomas R Jr · Mount Clare, WVBuilt 1972 · S/N 18261298 N20929Heinl Christopher · Hickory, NCBuilt 1972 · S/N 18261301 N2092GUllrich Sandy J · Haskell, OKBuilt 1958 · S/N 51392 N2092SMidwest Airmotive Inc · Mount Sterling, KYBuilt 1975 · S/N 21061058 N2092WEarthcirc08 LLC · Chagrin Falls, OHBuilt 1966 · S/N D-8044 N20935White Mark · Cadiz, KYBuilt 1972 · S/N 18261306 N20936Nedbalek Brent · Brenham, TXS/N 18261307

Back to AD 2000-23-21