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.

N2187UFearneyhough Jack M · Gilbertsville, KYBuilt 1979 · S/N 32-7940059 N21887Gilheany Robert V · Hicksville, NYBuilt 1974 · S/N 17264039 N2188GDisastermarks LLC · Miami, FLBuilt 1958 · S/N 51488 N2188RN2188r LLC · Pittsburgh, PABuilt 1969 · S/N 28-5481 N2188ZAlbright Duane C · Wasilla, AKBuilt 1963 · S/N 18051288 N21892Dove Aviation LLC · Greensboro, GABuilt 1978 · S/N 32R-7887237 N21893Western Territory Flyers LLC · Fairfax, CABuilt 1974 · S/N 17264040 N21899Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 32R-7887239 N2189DHoover Michael B · Ridgeland, WIS/N D-3536 N2189NFlight Operations Academy LLC · Chandler, AZBuilt 1979 · S/N 28R-7931050 N2189QBlue Hen Aviation Services LLC · Easton, PABuilt 1979 · S/N 28-7990298 N2189RSchrage James A · Danville, INBuilt 1969 · S/N 28-5482 N2189TTulsa Aviation Group Leasing LLC · Claremore, OKBuilt 1971 · S/N 28-7205041 N2189ZWeltin Gregory G · Kennebunk, MEBuilt 1981 · S/N 28-8190285 N218AZZavaleta Eric · Abilene, TXBuilt 2008 · S/N 3257486 N218CCSotally Tober LLC · Wilmington, DEBuilt 1979 · S/N 21063297 N218CGCourtney Melissa · San Diego, CABuilt 1980 · S/N E-1741 N218EABauer Todd A · Kenmare, NDBuilt 1970 · S/N 17259583 N218EWHartwig Aerial Spraying Inc · Edgeley, NDBuilt 1961 · S/N TD-466 N218KKSkymates Inc · Wilmington, DEBuilt 2002 · S/N 4496153 N218MMN218mm LLC · Portland, ORBuilt 1964 · S/N 2825 N218PPSumrell James E III · Bumpass, VABuilt 1976 · S/N 172-67520 N218RARozo Jhon B · Orlando, FLBuilt 1975 · S/N 17265450 N218SAInternational Air Services Inc Trustee · Carson City, NVS/N 24-1877 N218TSAeronautica LLC · West Hollywood, CABuilt 1966 · S/N 28-3675 N218USouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 310Q0507 N218WSeaplane Adventures LLC · Cheyenne, WYS/N 18255649 N218WGWilliams Sydney E · Kendallville, INBuilt 1969 · S/N 28R-35345 N218WPGriffin Kurt J · Gardnerville, NVS/N 28R-7803217 N218WSOrourke Brendan W · Stoughton, WIBuilt 1979 · S/N 28-8090094 N2190BVeritas Aero LLC · West Lafayette, INBuilt 1978 · S/N 32R-7985014 N2190DIntravaia Anthony J · Saint Louis, MOS/N D-3537 N2190FSachs Peter T · Naperville, ILBuilt 1965 · S/N U206-0390 N2190GScapegoat Aviation LLC · Choteau, MTBuilt 1958 · S/N 51490 N2190KArnold Mark W · Columbus, OHBuilt 1978 · S/N 34-7970096 N2190LSedine Aaron J · Cedar Springs, MIBuilt 1976 · S/N E-909 N2190PN2190p LLC · Titusville, FLS/N 23-799 N2190TGonzales Rene V · Lampasas, TXBuilt 1971 · S/N 28-7205029 N21914Autumn Air LLC · Prescott, AZBuilt 1977 · S/N D-10078 N2191BPetersburg Flying Service LLC · Petersburg, NEBuilt 1978 · S/N 32R-7985015 N2191DTips Daniel · Plano, TXBuilt 1953 · S/N D-3538 N2191EBel Air Aviation LLC · Chesaning, MIFirst renewal noticeBuilt 1978 · S/N 28-7990179 N2191FOhlinger Michael B · Mission, TXBuilt 1965 · S/N U206-0391 N2191LAir Leasing Service Inc · Hillsborough, NJS/N 28R-7918031 N2191R2gl P&I LLC · El Paso, TXS/N 18255391 N2191YDecker Ronnie L · Meno, OKBuilt 1962 · S/N 17249691 N2192GWood Kyle A · Soldotna, AKBuilt 1958 · S/N 51492 N2192TMazza Frank · Bridgeton, NJBuilt 1971 · S/N 28-7205043 N2192ZTalbott Erin W · Palouse, WAS/N 18051292 N2193RBig Island Gravity LLC · Kapaau, HIBuilt 1964 · S/N 18255393

Back to AD 98-21-21 R1