Skip to content

Registered aircraft · 85,620

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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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 N2080DSoller Nicholas · Plainsboro, NJBuilt 1953 · S/N D-3431 N2080EBean James P · Tulsa, OKBuilt 1978 · S/N 17271147 N2080LSparks Halli · Burdett, NYBuilt 1976 · S/N D-9902 N2080RTigert Tommy Ray · Ovilla, TXBuilt 1964 · S/N 18255280 N2080SRobinson Earl J · Cotuit, MABuilt 1966 · S/N D-8357 N2080VMcguire Rental Properties LLC · Prescott, ARBuilt 1979 · S/N 28-7916322 N20811Rtd Aviation LLC · Hillsborough, NJBuilt 1974 · S/N 17263843 N20816Dawson Matthew · Springfield, MOBuilt 1980 · S/N 32R-8029001 N20817Beard Russell G · Goodyear, AZBuilt 1978 · S/N 32R-7887179 N2081AKing David M · Ormond Beach, FLBuilt 1978 · S/N 32R-7885283 N2081CTrident Aircraft Inc · Easton, MDBuilt 1978 · S/N 28-7916128 N2081DSharon Enterprises LLC · Peralta, NMBuilt 1953 · S/N D-3492 N2081TBaker Holdings LLC · Bedford, PAS/N 28R-7135025 N2081WN5724v LLC · Kalispell, MTBuilt 1965 · S/N D-8007 N20820Maugeri Thomas V · Frankfort, NYBuilt 1972 · S/N 18261232 N20823American Patrols Inc · Midland, TXBuilt 1974 · S/N 17263848 N20824Seven Hills Skydivers Inc · Madison, WIFirst renewal noticeBuilt 1972 · S/N 18261236 N20825Sussman Stanley M · New Castle, DEBuilt 1974 · S/N 17263849 N20828Merrow R Loring · Beverly, MABuilt 1972 · S/N 18261238 N2082GKennedy Daniel M · Boise, IDBuilt 1958 · S/N 51382 N2082KGolden Ranch Aviation Inc · Schriever, LABuilt 1978 · S/N 34-7970072 N2082LChronicle Aerospace Inc · Wilmington, DEBuilt 1976 · S/N TK-20 N2082WRegistered aircraftBuilt 1965 · S/N D-8008 N20831Olg Air LLC · Miami Gardens, FLS/N 18261239 N20832Wallace Fred · Ada, OKBuilt 1972 · S/N 18261240 N20834Climb Maintain LLC · Morrisville, MOBuilt 1974 · S/N 17263850 N20836Morar Radu · Sutton, MABuilt 1972 · S/N 18261243 N20837Mjm Enterprise Holdings LLC · Drexel, MOBuilt 1974 · S/N 17263851 N20838Madden John D · Bellenue, WABuilt 1972 · S/N 18261245 N2083DSale Reported · Crystal, MNSale reportedBuilt 1978 · S/N 44-7995126 N2083LHorizon Chaser LLC · Woodway, TXS/N D-9904 N2083RSchutze Eric D Trustee · Ojai, CABuilt 1964 · S/N 18255283 N2083SDave Schmauderer · Woodland, CAS/N 21061049 N2083WKindig Eric J · Sidney, OHBuilt 1965 · S/N CD-990 N2083YJackson David W · Prescott Valley, AZBuilt 1962 · S/N 17249583 N20841Fox Creek Aviation LLC · Jackson, WYBuilt 1972 · S/N 18261248 N20842Warner Kenneth G · Granbury, TXBuilt 1972 · S/N 18261249 N20843St Louis Flying Club Inc · Ellisville, MOBuilt 1974 · S/N 17263853 N20845Clark Bradley D · Kirkwood, ILFirst renewal noticeS/N 18261252 N20848Lown Jeffrey B II · Shrewsbury, NJBuilt 1979 · S/N 28-7911080 N2084ASunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 44-7995081 N2084EBuchholz Steve DBA · Clarkston, MIBuilt 1978 · S/N 17271148 N2084GFlying Farmers LLC · Hills, MNBuilt 1958 · S/N 51384 N2084MAmdent Air LLC · Wyomissing, PAS/N 32-7840038 N2084PSchalk Bretta J · Fountain Run, KYBuilt 1956 · S/N 23-672 N2084RTej Builds Air LLC · Winchester, VABuilt 1964 · S/N 18255284 N2084SSecondhand Flying LLC · Ogden, UTBuilt 1975 · S/N 21061050 N2084THeiss Bryan G · Shelby, MIBuilt 1970 · S/N 28R-7135028 N2084WBurkett James Austin III · New Port Richey, FLBuilt 1965 · S/N D-8009

Back to AD 98-21-21 R1