Skip to content

Registered aircraft · 85,612

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.

N29535Clouse Tyler Woods · Forest City, IABuilt 1979 · S/N 28-7990448 N29537Garcia John C · Peoria, AZBuilt 1979 · S/N 28-7990449 N2953EJensen James A · Madison, WIBuilt 1978 · S/N 17271383 N2953QW-Wingmen LLC · Simi Valley, CABuilt 1977 · S/N 28R-7703084 N2953UClarkson Fredrich A · Oro Valley, AZBuilt 1979 · S/N 28-7990582 N29542Giannakakis Peter J · Monroe, MIBuilt 1973 · S/N 21059866 N2954BO'Conell David DBA · Butte, MTBuilt 1953 · S/N D-3595 N2954DRosales Mariano L III · Naperville, ILBuilt 1955 · S/N 26897 N2954FWestberg Wayne A · Harvey, IABuilt 1966 · S/N 18257054 N2954NLewman Daniel O Jr · Summit, MSBuilt 1979 · S/N 28-7990586 N2954QClark Ronald Joe · Scottsdale, AZBuilt 1979 · S/N 28R-7918234 N2954UTiger Flight LLC · Lake Butler, FLBuilt 1963 · S/N 17250554 N2954YFasano Garth · Boulder, COBuilt 1962 · S/N 18253954 N29552Montgomery Skyhawk LLC · Bethesda, MDBuilt 1974 · S/N 17264118 N2955BBiller Scott · Urbandale, IABuilt 1979 · S/N 28-7911285 N2955DWalsh David E · North Platte, NEBuilt 1955 · S/N 26898 N2955FBoyd John W · Milton, WABuilt 1966 · S/N 18257055 N2955MRls Rental Co DBA · Joplin, MOBuilt 1977 · S/N 28-7816326 N2955QAussieyank Air LLC · Reno, NVBuilt 1979 · S/N 28-7911265 N2955RSmith Billy V · Baton Rouge, LABuilt 1979 · S/N 28-7911266 N2955TFive Five Tango LLC · Rockford, ILBuilt 1979 · S/N 28-7911267 N2955YAda Forestry Division · Malvern, ARBuilt 1962 · S/N 18253955 N29566International Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 28R-7918146 N2956AHuebner Dennis Andrew · Morgan Hill, CABuilt 1979 · S/N 28-7911269 N2956BFlorida Coatings & Waterproofing LLC · Fort Pierce, FLS/N 28-7911270 N2956CFlying The Fields LLC · Algonquin, ILBuilt 1979 · S/N 28-7911271 N2956LZembower Christopher L · Cumberland, MDBuilt 1967 · S/N 670090 N2956PVann Dudley Carroll · Greenville, NCBuilt 1979 · S/N 28-7916583 N2956RFlightline LLC · Summerville, SCBuilt 1979 · S/N 28-7990588 N2956UMitchell Casey D · Lucedale, MSBuilt 1963 · S/N 17250556 N2956YRegistration Pending · Wilmington, DERegistration pendingBuilt 1962 · S/N 18253956 N2957CCurrier Dustan · Fairbanks, AKS/N 30857 N2957FRichardson John Daniel · Madisonville, LABuilt 1979 · S/N 28-7911273 N2957KSutton Aircraft Salvage LLC · Palmer, AKBuilt 1980 · S/N 18053138 N2957LJohnson Cullen L · Abernathy, TXS/N 670091 N2957MJacobson Larry · Commack, NYBuilt 1979 · S/N 28-7911274 N2957NBak John A · Lake Forest, CABuilt 1979 · S/N 32-7940228 N2957RBantle Aviation LLC · Midlothian, VABuilt 1979 · S/N 32-7940229 N2958CSale Reported · Anchorage, AKSale reportedBuilt 1954 · S/N 30858 N2958KPionair Inc · ChamBuilt 1980 · S/N 18053139 N2958LStormo Jarrod M · Indianapolis, INBuilt 1967 · S/N 670092 N2959DWatson Frank H · Central Point, ORBuilt 1955 · S/N 26902 N2959LMcphillips Jess H · Port Arthur, TXBuilt 1967 · S/N 670093 N2959MHanneman Robert · Claremore, OKBuilt 1977 · S/N 28-7890281 N2959QParis Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-7916585 N2959USmart5 LLC · Kissimmee, FLBuilt 1979 · S/N 28-7916588 N295BCWieler Jacob · Petty, TXS/N 28-7916435 N295BPQualitair LLC Trustee · MichelstadtBuilt 1975 · S/N 347570249 N295DAJackson Construction LLC · Charleston, SCBuilt 1968 · S/N 28-24582 N295DEFly Direct LLC · La Porte, INBuilt 1956 · S/N DH-88

Back to AD 98-21-21 R1