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.

N2772TRybakov Sergey N · Honolulu, HIBuilt 1967 · S/N TC-1032 N2772XBratten Douglas D · North Pole, AKBuilt 1965 · S/N 18051572 N2773FAdriatic Holdings LLC · Cheyenne, WYBuilt 1966 · S/N 18256873 N2773TPovilaitis Carl A · Glendale, CABuilt 1967 · S/N TE-376 N2773WStokes Robert A · Golden, COBuilt 1975 · S/N D-9720 N2773XLee Ty K · Anchorage, AKBuilt 1965 · S/N 18051573 N2774QRdj Brothers Trucking Inc · Bigfork, MTBuilt 1967 · S/N 18257974 N2774TOlson Electrical Services · Reno, NVS/N D-8481 N2774XElk Creek Investments LLC · Helena, MTBuilt 1965 · S/N 18051574 N2775FJock Carl A Trustee · Roscommon, MIBuilt 1966 · S/N 18256875 N2775QRay Chris J · Ironside, ORBuilt 1967 · S/N 18257975 N2775TWarner Jason David · Roseville, CAS/N D-8466 N2776AMccarthy Brian P · Yonkers, NYBuilt 1969 · S/N D-9054 N2776FBabovic Slobodan · Elm Grove, WIS/N 18256876 N2776GOliver Charles D · Saint Albans, WVBuilt 1959 · S/N 52076 N2776TGeorge John S · Abiquiu, NMS/N D-8480 N2776XSmith James A III · Millerton, NYBuilt 1965 · S/N 18051576 N2777AEagle Equity Inc · Valparaiso, INBuilt 1978 · S/N TC-2174 N2777BHollister Jet Center Inc · Hollister, CABuilt 1969 · S/N CE-281 N2777GPacheco Randy L · Pacific Grove, CABuilt 1959 · S/N 52077 N2777JFirst Flight LLC · Craig, AKBuilt 1969 · S/N 185-1527 N2777PChilds Patrick S · Jasper, TNBuilt 1967 · S/N D-8535 N2777XKruskie Douglas · Petoskey, MIS/N 18051577 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 N2779FSweatt D Wayne · Memphis, TXBuilt 1966 · S/N 18256879 N2779MFuist Richard · Lake City, FLS/N 28R-7803145 N277CDSkywalker Stratos LLC · Palo Alto, CABuilt 2026 · S/N 11428 N277CMMirasoles Produce USA LLC · Palmurst, TXBuilt 2020 · S/N 2209 N277CTRoss Peter W Trustee · Lufkin, TXBuilt 1998 · S/N EA-617 N277FRowland Maxwell J · League City, TXBuilt 1969 · S/N CJ-16 N277JKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1968 · S/N 18259292 N277JAMathieson Brett L · Rio Linda, CABuilt 2006 · S/N 41607 N277JDMeadows Construction Corp · Fort Smith, ARBuilt 2008 · S/N 3256 N277JMN541mg Inc · Big Pine Key, FLBuilt 1966 · S/N TE-215 N277LMRegistration Pending · Bend, ORRegistration pending, pending cancellationBuilt 2003 · S/N ES122 N277MDRegistered aircraftBuilt 1966 · S/N TE-223 N277MHEuroaviation Inc Trustee · KematenBuilt 1982 · S/N 28R8231035 N277MRSchab Davis Margaret A · Spangle, WABuilt 1966 · S/N TC-1012 N277RRossignoli Holdings LLC · Atlanta, GABuilt 2025 · S/N 11100 N277RBWaldo Pepper Flying Co · Wilmington, DEBuilt 1964 · S/N D-7473 N277TAAndersen Thomas E · Pleasant Valley, CTBuilt 1980 · S/N 25-0450 N277TMPollock Donald Edward · Union Hall, VABuilt 1976 · S/N 18264391 N277WLLozier Wesley · Farmington, ILBuilt 1977 · S/N D-10029 N277WWLee Aviation Co LLC · Pensacola, FLBuilt 2023 · S/N 9632 N277XSalopek Rett · Las Cruces, NMBuilt 1977 · S/N 414-0925 N2780GHolden Christa · Rougemont, NCBuilt 1958 · S/N 52080 N2780XMontgomery Jeffrey L · Anthem, AZBuilt 1965 · S/N 18051580 N2781DFejes Guide Service Ltd · Anchorage, AKBuilt 1979 · S/N 185-03892

Back to AD 2000-23-21