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.

N2889YJust Jump Skydiving LLC · Laurens, NYBuilt 1962 · S/N 18253889 N288AWilson Daniel T · Bandon, ORBuilt 1976 · S/N 32R-7680345 N288ABSyrasoft Aviation LLC · Baldwinsville, NYBuilt 1962 · S/N 24-3033 N288BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881751 N288CBCalifornia Baptist University · Riverside, CABuilt 2023 · S/N 2881635 N288FGroove LLC · Afton, VABuilt 1965 · S/N D-7970 N288FDFly Dynasty Corp · Ocala, FLBuilt 1967 · S/N 28-23767 N288GHBowen Christina M · Shreveport, LAS/N 28-1938 N288HGGeorgia Aviation Authority · Eastman, GABuilt 2002 · S/N 2842144 N288HPChaikin Steven · Kaunakakai, HIBuilt 2001 · S/N 2843482 N288LSVacendak William A · Wasilla, AKS/N 32953 N288LTGlatczak Jerome · Schofield, WIBuilt 1963 · S/N 18255038 N288MTgc Aviation LLC · Watkinsville, GABuilt 2002 · S/N E-3460 N288PBlue Water Aviation Inc · Jupiter, FLBuilt 1980 · S/N TH-1113 N288PASkywest Leasing Inc · St George, UTBuilt 2002 · S/N 2843502 N288RWNortheastern Assets Holdings LLC · Dover, NHS/N 18267369 N288SVMartin Terry L II · De Soto, MOBuilt 1995 · S/N 95-301022 N288TATurbine Time LLC · Mercer Island, WABuilt 1999 · S/N TH-1926 N288TBCejka Robert K · Cudahy, CABuilt 1975 · S/N TC-1880 N288TMSlaba Mark E · Arcadia, FLBuilt 1967 · S/N 18258263 N288WEAviators LLC · Edina, MNBuilt 1983 · S/N 32-8324008 N28907Warren Scott D · Lucerne, CABuilt 1979 · S/N 28-7990434 N2890CSpenchen Holdings LLC · Arnaudville, LAS/N 26433 N2890EHamilton Aerospace LLC · Lovettsville, VAS/N 28-7921086 N2890FAeolus Aviation LLC · Franklin, TNBuilt 1966 · S/N 18256990 N2890QCarrick Christopher A · Castro Valley, CABuilt 1971 · S/N 17259890 N2890URedley Andrew Scott · Maryville, TNBuilt 1963 · S/N 17250490 N2890WAlbatross Aviation LLC · Lakeville, OHBuilt 1973 · S/N D-9510 N2890YWomble Warren G · Chapel Hill, NCBuilt 1962 · S/N 18253890 N2891ARegistered aircraftBuilt 1953 · S/N 30091 N2891COconnell Edward P · Killingworth, CTBuilt 1954 · S/N 26434 N2891FBayshore Properties LLC · Hagerstown, MDBuilt 1966 · S/N 18256991 N2891GIsland Air Taxi LLC · Put In Bay, OHS/N 32-7940183 N2891TVagias Janet Rose · Niceville, FLBuilt 1972 · S/N 28-7225270 N2891YCherry Hill Aviation Inc · Freetown, INS/N 32-7940185 N28920Wakeman Henry K III · Etna, NHBuilt 1986 · S/N E-2330 N28926Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881233 N2892CPatrick John A · Los Molinos, CABuilt 1954 · S/N 26435 N2892EJaars Inc · Waxhaw, NCBuilt 1978 · S/N 17271363 N2892FSpeedtape Airways LLC · Williamson, GABuilt 1966 · S/N 18256992 N2892LSellers Michael E · Clam Gulch, AKBuilt 1967 · S/N 17256092 N2892RBuenafe Constance Ann · Santa Fe, NMBuilt 1967 · S/N 18258492 N2892TScherman Dale M · Ottertail, MNBuilt 1972 · S/N 28-7225272 N28933Lewis Group Properties LLC · Apex, NCBuilt 1979 · S/N 32-7940123 N28934Johnson Grant M · Odessa, FLBuilt 1981 · S/N 32R-8129008 N28935Kremer Brian F · Iona, MNBuilt 1979 · S/N 32-7940124 N2893CChapel Hill Flying Club DBA · Sanford, NCS/N 28-7916517 N2893EN2893e LLC · Reno, NVBuilt 1978 · S/N 17271364 N2893LKhalaf Maher · Canton, MIBuilt 1979 · S/N 28-7916520 N2893MRls Rental Co Inc DBA · Joplin, MOBuilt 1977 · S/N 28-7816321

Back to AD 98-21-21 R1