Registered aircraft · 47,138

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:2000-23-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21') 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:2000-23-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
  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:2000-23-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
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.

N2650FFlight Time LLC · Highland, MIBuilt 1966 · S/N 18256750 N2650GNewkirk Kevin J · Manhattan, KSS/N 51950 N26514Hyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0344 N2651FMars Aviation LLC · Commerce City, COBuilt 1965 · S/N 18256751 N2651SHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0342 N2651VHagl Aviation LLC · Sunray, TXBuilt 1976 · S/N R1722226 N2652FMartindale Lloyd M · Bellingham, WABuilt 1965 · S/N 18256752 N2652RDevries Francis P · Justin, TXBuilt 1967 · S/N 18258352 N2653Barr Air Patrol LLC · Mesquite, TXBuilt 1982 · S/N 18268297 N2653FBagstad Lance · Park Rapids, MNBuilt 1965 · S/N 18256753 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 N2654FGregory Daniel · Virginia Beach, VABuilt 1966 · S/N 18256754 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 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 N2656KT And H Aircraft Leasing LLC · Yakutat, AKBuilt 1978 · S/N 18053029 N2656QPankrate Kenneth W · Opheim, MTS/N 18257856 N2656REdex Aviation LLC · Sutter Creek, CAS/N 18258356 N2656SPierini William C · Chico, CABuilt 1976 · S/N 21061346 N2657FPoolshark Equipment LLC · Memphis, TNBuilt 1965 · S/N 18256757 N2657S57 Sierra LLC · Houston, TXBuilt 1968 · S/N 337-0957 N2657YNagy Leslie S · Walnut Creek, CABuilt 1962 · S/N 18051157 N2658BBrowning Frank W · Port Orange, FLBuilt 1986 · S/N CE-1086 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 N2658ZVirtue Genetics LLC · Cedar Rapids, IAS/N 421C0827 N26595Levy Alfred E · Richardson, TXBuilt 1971 · S/N 18260616 N2659BAnderson Brian E · York, PABuilt 2002 · S/N 0237 N2659GMarmon David J · Great Falls, MTBuilt 1959 · S/N 51959 N2659KWickline Wayne · Flower Mound, TXBuilt 1985 · S/N 18268502 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 N2659UMec Management LLC · Wilmington, DEBuilt 1986 · S/N E-2316 N265ASCapital Holdings 221 LLC · Newark, DEBuilt 2021 · S/N 2425 N265CESeven Out Aviation LLC · Rio Verde, AZBuilt 2023 · S/N 9452 N265DBKlw Coastal Equipment LLC · Destin, FLBuilt 2008 · S/N TH-2241 N265DTLynn Daniel K · Beaverton, ORBuilt 1975 · S/N 18264034 N265HPN265hp LLC · Parachute, COBuilt 1985 · S/N 18268519 N265JCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 2092 N265JKArchiekilo Aviation LLC · Houston, TXBuilt 2024 · S/N 10177 N265JPN265jp LLC · Mill Valley, CABuilt 2004 · S/N 0888 N265KBCedaron Medical Inc · Davis, CABuilt 2019 · S/N TH-2523 N265KGCavu 1989 LLC · New Hope, PABuilt 2024 · S/N 10160

Back to AD 2000-23-21