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.

N2818FMccullough Andrew · Lubbock, TXS/N 18256918 N2818MMarotta Robert J · San Diego, CABuilt 1979 · S/N 28-7990462 N2818SAviator Antics LLC · Grand Forks, NDBuilt 1979 · S/N 28-7990466 N2818TLb33 LLC · Helena, MTBuilt 1972 · S/N 28-7225239 N2818UWard Jasper Eugene · Telford, TNFirst renewal noticeS/N 17250418 N2818XBarr Suzanne Renee · Cape Coral, FLBuilt 1979 · S/N 28-7990467 N2818YEaton Melvin W II · Saint Onge, SDS/N 18253818 N28191Ashurst Joe D · Wheatland, WYBuilt 1979 · S/N 79-30913 N28195Richard C Rinks & Assoc Inc · Cookeville, TNBuilt 1979 · S/N 79-30938 N2819CLanis Scott E · North Pole, AKBuilt 1954 · S/N 26362 N2819DAicg Group I LLC · Sheridan, WYBuilt 1979 · S/N 28-7990469 N2819FMacair LLC · Kennesaw, GABuilt 1979 · S/N 28R-7918156 N2819QAirborne LLC · Wilmington, DEBuilt 1971 · S/N 17259819 N2819TMelvin Haigis Jr · Bardstown, KYBuilt 1972 · S/N 28-7205227 N2819UGartner Thomas M · Newton, KSBuilt 1963 · S/N 17250419 N2819VElgin Sky Snoopers Inc. · Crystal Lake, ILBuilt 1947 · S/N D-221 N281ARKing Scott · Knoxville, TNBuilt 1978 · S/N TH-991 N281BGD&J Aviation LLC · Apopka, FLBuilt 2006 · S/N 2842280 N281BLWingsleasing LLC · Wichita, KSBuilt 2023 · S/N 2881665 N281BMMcilroy Bob · Charlotte, NCBuilt 1979 · S/N 79-30933 N281CAFarrugia Joe · Cleveland, TXBuilt 1979 · S/N 28R-7918121 N281CFCharlie Foxtrot Corp · Colleyville, TXBuilt 1977 · S/N 28-7816111 N281HPMuggles Ltd LLC · East Fallowfield, PABuilt 2000 · S/N 2843323 N281KCFly Kilo Charlie LLC · New Century, KSS/N 28-8216130 N281NDPlane Nonsense Inc · Middletown, DEBuilt 1998 · S/N 2844015 N281PBMartin Robert F Jr · Fort Deposit, ALBuilt 1963 · S/N D-7255 N281RWalker Lawrence J · Haymarket, VABuilt 1964 · S/N TC-757 N281RABluewater Airmotive Corp · Wilmington, DEBuilt 1976 · S/N 28-7615352 N281RCCavett Richard A · Enderlin, NDBuilt 1973 · S/N 74-30619 N281RMHolthaus Craig J · Canton, ILBuilt 1979 · S/N 25-0059 N281STucker Daniel · Weatherford, TXBuilt 1968 · S/N TE-566 N281SLCurly Aviation LLC · Atlanta, GABuilt 1972 · S/N 182-61394 N281SVOlson Fred · Harrison, ARBuilt 2000 · S/N 00-301029 N281TMalerba David · Morrison, COBuilt 1967 · S/N D-8508 N281TWSkywest Leasing Inc · St George, UTBuilt 2018 · S/N 2881091 N281UDStanley David Wayne · Burleson, TXBuilt 1981 · S/N P21000690 N281VBarry Larry M · Woodbine, IAS/N D-8195 N28200Holland Joshua · Glendale, AZBuilt 1978 · S/N 78-31149 N28201Viking 28201 LLC · El Dorado Hills, CABuilt 1978 · S/N 78-30903 N28208Registered aircraftAssigned, pending cancellationS/N 78-30898 N2820DAbdullah Ibrahim M · Las Vegas, NVS/N 28R-7931210 N2820JChabot Nicholas · West Hartford, CTBuilt 1979 · S/N 28-7911189 N2820LHarrington Thomas W Jr · Cumming, GAS/N 17256020 N2820NMontana Tvl Aviation LLC · Kalispell, MTBuilt 1979 · S/N 28-7911191 N2820QBush Steven B · Lago Vista, TXBuilt 1971 · S/N 17259820 N2820RHutter Karl G · Reno, NVBuilt 1967 · S/N 18258420 N2820VLundstedt Garry R · Fort Collins, COBuilt 1947 · S/N D-222 N2821ALewton John E · Belgrade, MTBuilt 1953 · S/N 30021 N2821GH&M Air LLC · Metamora, MIBuilt 1979 · S/N 32-7940137 N2821K4608 Vista LLC · Fort Lauderdale, FLS/N 18053089

Back to AD 98-21-21 R1