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.

N2050ETcv Capital Holdings LLC · Riverton, UTBuilt 1978 · S/N 17271132 N2050GSaunders Timothy Scott · Utopia, TXBuilt 1958 · S/N 51350 N2050NPerks Andrew · Weatherford, TXBuilt 1978 · S/N E-1429 N2050PDzvonik Eugen · Murray, UTBuilt 1956 · S/N 23-634 N2050RMills James A · Fayetteville, GABuilt 1964 · S/N 18255250 N2050SDavis Bryan C · Winfield, KSBuilt 1975 · S/N 21061017 N2050XWhite Levi E · Joliet, MTBuilt 1965 · S/N 18256150 N2050YSomerville Elizabeth M · West Dennis, MABuilt 1978 · S/N CE-826 N2050ZPong William Robert · San Mateo, CABuilt 1978 · S/N D-10193 N20512Fly Guys LLC · Cross Lanes, WVBuilt 1973 · S/N 17261350 N20514Bales Gregory W · Enterprise, ORBuilt 1981 · S/N 18053190 N20516Arndt Scott D · Pearland, TXBuilt 1973 · S/N 17261354 N2051BPlanepower LLC · Meridian, MSBuilt 1978 · S/N TC-2196 N2051GRumiano Gary J · Vina, CABuilt 1958 · S/N 51351 N2051KSocio Aviation Services LLC · Benton, KYBuilt 1978 · S/N D-10198 N2051R2051 Aviation LLC · Spokane, WAS/N 18255251 N2051WLeiwant Alan J · Montville, NJBuilt 1978 · S/N E-1410 N2051XArana Carlos · The Woodlands, TXBuilt 1978 · S/N E-1411 N2051YMomba LLC · New Braunfels, TXBuilt 1962 · S/N 17249551 N20520Treats Aviation Inc · Enumclaw, WABuilt 1973 · S/N 17261358 N20521N20521 LLC · Wilmington, DEBuilt 1973 · S/N 17261359 N20522Sale Reported · Paulista SpSale reported, canceledBuilt 1982 · S/N R18201924 N20526Chester Steven G · Aurora, COBuilt 1973 · S/N 17261363 N20528Vfr Aviation LLC · Clayton, NYBuilt 1973 · S/N 17261365 N2052MDehnel Kris P · Cedar Park, TXS/N 28-7890222 N2052RDybvig Abraham M · Bothell, WABuilt 1969 · S/N 28-5444 N20531Fuller David C · Vinton, TXBuilt 1973 · S/N 17261368 N20532Superhawk Inc · Marcell, MNS/N 17261369 N20533Big Sky Aviation LLC · El Campo, TXBuilt 1973 · S/N 17261370 N2053WOem Products Inc · Oklahoma City, OKBuilt 1965 · S/N D-7990 N2053XGolden Richard J · Stafford, VABuilt 1965 · S/N 18256153 N20540Baum Martin L · Bullard, TXS/N 27-4193 N20541University Of Alaska Anchorage · Anchorage, AKS/N 17261378 N20542Roberge Patrick R · Columbus, OHBuilt 1973 · S/N 17261379 N20543Sierra Delta Aircraft LLC · Kalispell, MTBuilt 1973 · S/N 17261380 N20544Walla Walla University · College Place, WABuilt 1973 · S/N 17261381 N2054CParker Jerry B · Arcola, TXBuilt 1959 · S/N TD-245 N2054EJamieson Mark S · Boulder, COBuilt 1978 · S/N 17271133 N2054G54g Group · Seattle, WABuilt 1958 · S/N 51354 N2054MMcdonald Patrick R · Waverly Township, PABuilt 1977 · S/N 28-7890223 N2054NHampton Todd J · Plainfield, INBuilt 1978 · S/N D-10196 N2054RRiptide Investments LLC · Baker, FLBuilt 1964 · S/N 18255254 N2054WVerran Clinton T · Rochester Hills, MIBuilt 1965 · S/N D-7991 N2054XVoz Garth O · Gonzales, TXBuilt 1965 · S/N 18256154 N2054YPetersen Paul R · Eldridge, IABuilt 1962 · S/N 17249554 N20550Traskos Larry L Trustee · Port Orange, FLBuilt 1981 · S/N 18053194 N20552Robertson William J · Athens, TNBuilt 1973 · S/N 17261387 N20553Green Jeffrey L · Herrick, ILBuilt 1973 · S/N 17261388 N20554Danekas Inc · Colville, WABuilt 1973 · S/N 17261389 N20555Buiqui Aerospace Corp · Kissimmee, FLBuilt 1973 · S/N 17261390

Back to AD 98-21-21 R1