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.

N2653GDevine Christopher C · Eagle River, AKBuilt 1959 · S/N 51953 N2653M97 Lima LLC · Edina, MNBuilt 1986 · S/N E-2315 N2653QMoses And Associates Inc · Gainesville, FLBuilt 1966 · S/N 18257853 N2653TValley Aircraft Restoration Society Inc · Phoenix, AZBuilt 1971 · S/N 28-7210001 N2653UClark Nikita C · Ontario, ORS/N 17250253 N2653WDyer Perri P · Argyle, TXS/N 984 N2654ESch Aviation Inc Trustee · Sporle Kings LynnBuilt 1971 · S/N 39-93 N2654FGregory Daniel · Virginia Beach, VABuilt 1966 · S/N 18256754 N2654LGriner Carrie L · Auburndale, FLBuilt 1967 · S/N 17255854 N2654RFindarle John J · Midway, UTBuilt 1967 · S/N 18258354 N2654YHolty Joseph G · Fairbanks, AKBuilt 1962 · S/N 18051154 N2655CSmith Lionel J · Ironton, MOBuilt 1955 · S/N 35055 N2655DSutton Aircraft Salvage LLC · Palmer, AKBuilt 1956 · S/N 20807 N2655GBeachy Benjamin D · Whittington, ILBuilt 1959 · S/N 51955 N2655QRedmond Angela L · Austin, TXBuilt 1966 · S/N 18257855 N2655RBeck Bartholomew · Dry Ridge, KYBuilt 1967 · S/N 18258355 N2655ZRegistered aircraftN-number assigned (import), not yet registeredS/N 185-0655 N2656CHgta Partners LLC · Grand Rapids, MIBuilt 1978 · S/N R18200196 N2656KT And H Aircraft Leasing LLC · Yakutat, AKBuilt 1978 · S/N 18053029 N2656LSzymanski Alexander G · Hernando, MSBuilt 1967 · S/N 17255856 N2656QPankrate Kenneth W · Opheim, MTS/N 18257856 N2656REdex Aviation LLC · Sutter Creek, CAS/N 18258356 N2656SPierini William C · Chico, CABuilt 1976 · S/N 21061346 N2656TCardinal Point Aviation Services LLC · Homestead, FLBuilt 1971 · S/N 28-7225079 N2656VMccurdy James Rodney · Statesville, NCS/N 18166 N2657DBouvrie Lukas J · Boulder, COBuilt 1952 · S/N 20809 N2657FPoolshark Equipment LLC · Memphis, TNBuilt 1965 · S/N 18256757 N2657USzymanski Janet M · Alanson, MIBuilt 1963 · S/N 17250257 N2657WRegistered aircraftBuilt 1966 · S/N 3310 N2657YNagy Leslie S · Walnut Creek, CABuilt 1962 · S/N 18051157 N2658BBrowning Frank W · Port Orange, FLBuilt 1986 · S/N CE-1086 N2658CMay Jeffrey P · Seligman, AZBuilt 1978 · S/N R18200198 N2658FClayton Alfred T · Anchorage, AKBuilt 1965 · S/N 18256758 N2658GSauer Roger A · Glenburn, NDBuilt 1959 · S/N 51958 N2658RNorthern Science Services LLC · Anchorage, AKBuilt 1967 · S/N 18258358 N2658TLoer Stanley W · Grants Pass, ORBuilt 1971 · S/N 28-7205067 N2658VGriffin Robert L · Warren, OHBuilt 1948 · S/N 18168 N2658WPerez Dennys · Orlando, FLBuilt 1966 · S/N 987 N26595Levy Alfred E · Richardson, TXBuilt 1971 · S/N 18260616 N2659GMarmon David J · Great Falls, MTBuilt 1959 · S/N 51959 N2659QMorrison Mark C · Marfa, TXBuilt 1966 · S/N 18257859 N2659RBerrios Antonio · Genoa, ILBuilt 1967 · S/N 18258359 N2659SRovey Gerald A · Troy, IDBuilt 1973 · S/N 18502261 N2659TLeja Surveying Corp · Yucaipa, CABuilt 1971 · S/N 32-7240036 N2659UMec Management LLC · Wilmington, DEBuilt 1986 · S/N E-2316 N2659WMooney Flyer LLC · Belton, SCBuilt 1966 · S/N 1007 N265AAWhitten Chris K · Alton, MOBuilt 1958 · S/N TD-132 N265ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496098 N265DTLynn Daniel K · Beaverton, ORBuilt 1975 · S/N 18264034 N265ERAerosolutions Group Inc · Wilmington, DEBuilt 1976 · S/N 17268081

Back to AD 98-21-21 R1