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.

N2795LHarkness Paul E · Richmond Hill, GABuilt 1967 · S/N 17255995 N2795URichardson Robert S · Austin, TXBuilt 1963 · S/N 17250395 N2795VBas Part Sales LLC · Greeley, COBuilt 1947 · S/N D-190 N2796DFrance Gregory G · Alta Loma, CABuilt 1952 · S/N 25338 N2796FX-Ray Engineering Corp · Port Orange, FLS/N 18256896 N2796GDouglas Cattle LLC · Douglas, AZBuilt 1959 · S/N 52096 N2796LSmyth Michael L · Saint Charles, MOBuilt 1967 · S/N 17255996 N2796TPozdolski Casey · Los Osos, CABuilt 1967 · S/N D-8491 N2796WPennington Jeffrey B · Wrightwood, CABuilt 1966 · S/N 1072 N2797ABlue Line Aviation LLC · Vidalia, GABuilt 1969 · S/N D-9055 N2797DEberhart Wayne Willis · Amboy, MNBuilt 1952 · S/N 25339 N2797EPalm Beach Flyers LLC · Boca Raton, FLS/N 17271324 N2797FWhatley Charles J · Goliad, TXBuilt 1965 · S/N 18256897 N2797JAlaska Ultimate Safaris LLC · Homer, AKBuilt 1969 · S/N 185-1555 N2797TD'Angelo Brothers Development LLC · Helena, MTBuilt 1967 · S/N D-8486 N2797WWebb John H Jr · Paulding, OHBuilt 1966 · S/N 1073 N27989Csc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 31-7952077 N2798CStone Aviation LLC · Sacramento, CABuilt 1978 · S/N R18200228 N2798EPumpkin Eater LLC · Tavares, FLBuilt 1978 · S/N 17271325 N2798FGoodall Maurice M II · Omak, WABuilt 1966 · S/N 18256898 N2798GBremerton City Flying Club · Poulsbo, WABuilt 1959 · S/N 52098 N2798PNautilus Air LLC · Omaha, NEBuilt 1986 · S/N E-2337 N2798TPatriot Aviation Logistics LLC · Lewes, DEBuilt 1967 · S/N D-8488 N2798VPorte Elvis · Miami, FLBuilt 1947 · S/N D-193 N2798WSb Enterprise LLC · Marshall, TXBuilt 1966 · S/N 3367 N2798XElsner Kelly John · Menahga, MNBuilt 1965 · S/N 18051598 N27990Aztec Worldwide Airlines Inc · Wilmington, DEBuilt 1979 · S/N 31-7952079 N2799CTaylor James L · Lowell, ARBuilt 1954 · S/N 26343 N2799GMartin Aviation LLC · Scottsboro, ALS/N 52099 N2799QZerden David F · Lincoln Park, NJBuilt 1972 · S/N 18261592 N2799UWinslow Linda S Trustee · Creswell, ORS/N 17250399 N2799XHess James R · Heathsville, VABuilt 1965 · S/N 18051599 N279AGWings Over Texas Holdings LLC · Denton, TXBuilt 2020 · S/N 4496507 N279CGDelaware State University · Dover, DEBuilt 2000 · S/N 2843399 N279CMMckenzie Robert A · Downers Grove, ILBuilt 1969 · S/N 18259822 N279JHBravo Zulu Aviators LLC · Midland, TXBuilt 1978 · S/N 32-7840138 N279JSAnnapolis Aviation LLC · Annapolis, MDBuilt 1978 · S/N 18266499 N279LGAltius Aviation LLC · Syracuse, NYBuilt 1986 · S/N 28-8611004 N279MCMagic Carpet LLC · Wilmington, DEBuilt 1954 · S/N 26331 N279MGGeorgia Aviation Authority · Eastman, GABuilt 2018 · S/N 2881020 N279NDSowela Technical Community College · Lake Charles, LABuilt 2000 · S/N 2844034 N279PWMauck Ryan S Trustee · Bend, ORBuilt 1985 · S/N 28-8590059 N279RWPoe James K · Walterboro, SCBuilt 1959 · S/N 52347 N279SRMetro Aircraft Co · Bloomington, MNBuilt 1979 · S/N 28R-7918130 N279SVGeorge W Goodknight Inc · Chattanooga, OKBuilt 1979 · S/N 79-30939 N27ABSailaway Management Inc · Wilmington, DES/N 25-0431 N27AHM W T Aviation LLC · Jamestown, NYBuilt 1975 · S/N 17265306 N27AKLingle Bryan K Sr · Bradenton, FLBuilt 1979 · S/N 18266826 N27AUAndrews University · Berrien Springs, MIBuilt 2014 · S/N 2843768 N27BSl Leasing Group LLC · Barnesville, GABuilt 1975 · S/N 21061108

Back to AD 98-21-21 R1