Skip to content

Registered aircraft · 20,483

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N20806Young Todd Frederick · Pensacola, FLBuilt 1972 · S/N 18261220 N2080JWoelfel Tim A · Madisonville, TXBuilt 1978 · S/N T18803370T N2080RTigert Tommy Ray · Ovilla, TXBuilt 1964 · S/N 18255280 N20820Maugeri Thomas V · Frankfort, NYBuilt 1972 · S/N 18261232 N20824Seven Hills Skydivers Inc · Madison, WIFirst renewal noticeBuilt 1972 · S/N 18261236 N20828Merrow R Loring · Beverly, MABuilt 1972 · S/N 18261238 N2082GKennedy Daniel M · Boise, IDBuilt 1958 · S/N 51382 N2082JCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1978 · S/N T18803372T N20831Olg Air LLC · Miami Gardens, FLS/N 18261239 N20832Wallace Fred · Ada, OKBuilt 1972 · S/N 18261240 N20836Morar Radu · Sutton, MABuilt 1972 · S/N 18261243 N20838Madden John D · Bellenue, WABuilt 1972 · S/N 18261245 N2083RSchutze Eric D Trustee · Ojai, CABuilt 1964 · S/N 18255283 N2083SDave Schmauderer · Woodland, CAS/N 21061049 N20841Fox Creek Aviation LLC · Jackson, WYBuilt 1972 · S/N 18261248 N20842Warner Kenneth G · Granbury, TXBuilt 1972 · S/N 18261249 N20845Clark Bradley D · Kirkwood, ILFirst renewal noticeS/N 18261252 N2084GFlying Farmers LLC · Hills, MNBuilt 1958 · S/N 51384 N2084RTej Builds Air LLC · Winchester, VABuilt 1964 · S/N 18255284 N2084SSecondhand Flying LLC · Ogden, UTBuilt 1975 · S/N 21061050 N2084XPrier Duncan M · Bonita Springs, FLBuilt 1965 · S/N 18256184 N20852Spaulding Kenneth L · Sahuarita, AZBuilt 1972 · S/N 18261258 N20854Branson Bonanza Club · Branson, MOBuilt 1972 · S/N 18261260 N20855Mission Aviation LLC · Billings, MTBuilt 1972 · S/N 18261261 N20856Pointon Martin J · Snohomish, WABuilt 1972 · S/N 18261262 N20859Anderas Per R · Green Bay, WIS/N 18261264 N2085GBackcountry Guys LLC · Prescott, AZS/N 51385 N2085SRichards John · Casa Grande, AZBuilt 1975 · S/N 21061051 N2085XBrian Murray J · Pekin, ILBuilt 1965 · S/N 18256185 N20862Barrington Aviation LLC · Kalamazoo, MIBuilt 1972 · S/N 18261267 N2086GHigh Country Aces LLC · Cove, ARBuilt 1958 · S/N 51386 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 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 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 N2089STxt Aviation LLC · Deland, FLS/N R18201299 N2089XMoravitz Kim J · Turtle Lake, WIBuilt 1965 · S/N 18256189 N208LHOtt Grosvenor LLC · Dillingham, AKBuilt 1974 · S/N U20602642 N208TCKissee Zachary Robert · Chugiak, AKBuilt 1976 · S/N 18052749 N208WPCassidy Ryan H · Seattle, WABuilt 1980 · S/N U20605836 N20907Ward Roger L · Ghent, WVBuilt 1972 · S/N 18261345 N2090GLight Chop LLC · Lexington Park, MDBuilt 1958 · S/N 51390 N2090XTreeline Services LLC · Grimes, IAS/N 18256190

Back to AD 84-10-01 R1