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.

N2776UGarrison Randy · Queen City, TXBuilt 1963 · S/N 17250376 N2776WBowers Curt E · Jennings, LAS/N 1060 N2776XSmith James A III · Millerton, NYBuilt 1965 · S/N 18051576 N2776YMadlener Michael J · Las Vegas, NVBuilt 1958 · S/N TD-145 N2777BHollister Jet Center Inc · Hollister, CABuilt 1969 · S/N CE-281 N2777ETop Flight Aviation Inc · Corona, CABuilt 1974 · S/N 17262885 N2777GPacheco Randy L · Pacific Grove, CABuilt 1959 · S/N 52077 N2777JFirst Flight LLC · Craig, AKBuilt 1969 · S/N 185-1527 N2777LHataway Gregory L · Kinston, ALBuilt 1967 · S/N 17255977 N2777NSpencer John · Indian, AKS/N 32-7240003 N2777PChilds Patrick S · Jasper, TNBuilt 1967 · S/N D-8535 N2777TAviator Air Flight School LLC · Grand Prairie, TXBuilt 1972 · S/N 17261147 N2777XKruskie Douglas · Petoskey, MIS/N 18051577 N2778DBaker Julius W · Anchorage, AKBuilt 1952 · S/N 25320 N2778FHuber George M · Bentonville, ARBuilt 1966 · S/N 18256878 N2778JWilfer Dennis M · Fairbanks, AKBuilt 1969 · S/N 185-1528 N2778THavrick Jason T · Bridgeport, TXBuilt 1967 · S/N TE-378 N2778URoberts Kenneth B · Wall Township, NJBuilt 1963 · S/N 17250378 N2778VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1947 · S/N D-170 N2779DLumley Carol J · Eagle River, WIBuilt 1952 · S/N 25321 N2779FSweatt D Wayne · Memphis, TXBuilt 1966 · S/N 18256879 N2779LResetar Douglas J · Pittsford, NYBuilt 1967 · S/N 17255979 N2779MFuist Richard · Lake City, FLS/N 28R-7803145 N277AMParis Air Inc · Vero Beach, FLBuilt 1974 · S/N 34-7450188 N277CBN277cb LLC · Jacksonville, FLBuilt 1976 · S/N 17267516 N277CTRoss Peter W Trustee · Lufkin, TXBuilt 1998 · S/N EA-617 N277DDWicked Flyby LLC · Lewes, DEBuilt 1960 · S/N 24-1818 N277DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010077 N277FRowland Maxwell J · League City, TXBuilt 1969 · S/N CJ-16 N277JKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1968 · S/N 18259292 N277JMN541mg Inc · Big Pine Key, FLBuilt 1966 · S/N TE-215 N277LGAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881909 N277MDRegistered aircraftBuilt 1966 · S/N TE-223 N277MHEuroaviation Inc Trustee · KematenBuilt 1982 · S/N 28R8231035 N277MMSolan Richard J · Canaan, CTS/N 28-7325295 N277MRSchab Davis Margaret A · Spangle, WABuilt 1966 · S/N TC-1012 N277PSparks Nathan G · Knoxville, TNBuilt 1955 · S/N D-4230 N277RBWaldo Pepper Flying Co · Wilmington, DEBuilt 1964 · S/N D-7473 N277RMSoutheast Design & Manufacturing LLC · Sun City Center, FLBuilt 1975 · S/N 28-7515354 N277SAFox Matthew C · Athlone WestheathNon-citizen corporation, flight hours not reportedS/N 28-21661 N277SLCharlies Wings LLC · Salisbury, NCBuilt 1973 · S/N 17261652 N277SMKroha Michael D · Southbury, CTBuilt 1980 · S/N 28-8011072 N277TAAndersen Thomas E · Pleasant Valley, CTBuilt 1980 · S/N 25-0450 N277TMPollock Donald Edward · Union Hall, VABuilt 1976 · S/N 18264391 N277VCusick Christopher J · La Jolla, CABuilt 1954 · S/N CH-88 N277WLLozier Wesley · Farmington, ILBuilt 1977 · S/N D-10029 N27800International Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 31-7852156 N27808St George Flight Academy LLC · St George, UTBuilt 1971 · S/N 17260023 N2780CWheeler Russell E · Roxbury, CTBuilt 1954 · S/N 26324 N2780DChythlook Joseph L · Dillingham, AKS/N 25322

Back to AD 98-21-21 R1