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.

N250GCCarroll James E Trustee · Newington, NHBuilt 1977 · S/N 18266130 N250GTComanche Golf Tango LLC · Clifton, VAS/N 24-2496 N250HCCornerstone Air Holdings LLC · Fort Scott, KSBuilt 1977 · S/N 32R-7880037 N250KBodrero Roger Jay · Outlook, WABuilt 1952 · S/N 20659 N250LMenefee Scott A · Los Banos, CABuilt 1979 · S/N R18200936 N250LJCarew Aviation Inc · Appleton, WIBuilt 1964 · S/N 24-3393 N250MDInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 31-742 N250MLAlpha Aero Repair LLC · Dousman, WIBuilt 1973 · S/N CE-475 N250MMMone Forwarding Lc · Laredo, TXBuilt 1980 · S/N TJ-261 N250PCHerndon Timothy M · Kingston, OKBuilt 1959 · S/N 24-1133 N250RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266043 N250RBWestern Slope Aviators LLC · Delta, COBuilt 1958 · S/N 24-334 N250RTMatthews Aviation LLC · Hardinsburg, KYBuilt 1971 · S/N 27-4681 N250TASunset Aviation LLC · Halifax, PABuilt 1974 · S/N 27-7405364 N250TCGroth William B · Hixson, TNBuilt 1969 · S/N D-9048 N250TJTalley John T · Clifton, TXBuilt 1959 · S/N 24-1048 N250WAWelch Eric · Lakeland, TNBuilt 1978 · S/N 32-7840102 N250WFGita Aviation LLC · Dallas, TXBuilt 1978 · S/N 28-7916088 N250YMyers Mark E · Rogers, ARBuilt 1966 · S/N CD-1065 N2510MYonder Corp · Wilmington, DEBuilt 1979 · S/N 27-7954070 N2510Q901 Aviation LLC · Oxford, MSS/N 32R-7780249 N2510XRegistration Pending · West Hartford, CTRegistration pendingBuilt 1985 · S/N 32-8606001 N2511798x LLC · Caddo Mills, TXBuilt 1970 · S/N 17259514 N2511DDfs2024 LLC · Edwards, COBuilt 1979 · S/N 18266873 N2511LDmcflight LLC · Boynton Beach, FLS/N 17255711 N2511RDickey Mark D · Pendleton, ORS/N 18258211 N2511VSutton Aircraft Salvage LLC · Palmer, AKBuilt 1948 · S/N 18014 N2512GSutton Aircraft Salvage LLC · Palmer, AKBuilt 1959 · S/N 51812 N2512QPeacock Jeffery D · Cleburne, TXS/N 18257712 N2512UNative Sons Aviation LLC · Lake Placid, FLBuilt 1963 · S/N 17250112 N2512VNichol Nathan P · Anchorage, AKS/N 18020 N2513DPetite Randall L · Lake Tapps, WABuilt 1952 · S/N 20665 N2513GSedlickas Mark A · Graham, WABuilt 1959 · S/N 51813 N2513KCarlson Thomas G · Anchorage, AKBuilt 1978 · S/N 18052964 N2513LDahlberg James C · Ogilvie, MNBuilt 1966 · S/N 17255713 N2513VMcrobie Roger L · Maryville, TNBuilt 1948 · S/N 18016 N2513XChristenson Cole R · West Fargo, NDBuilt 1964 · S/N P206-0013 N2513YWilson Hubert Ernest · Gustavus, AKBuilt 1962 · S/N 17249813 N2514CPayne Jonathan R · Montgomery, ALBuilt 1954 · S/N 26158 N2514DWeindel Victoria E · Anchorage, AKBuilt 1952 · S/N 20666 N2514LRegistration Pending · Macclenny, FLRegistration pendingS/N 17255714 N2514RRichmond Patrick A · Glenmora, LABuilt 1967 · S/N 18258214 N2514UHenson David C · Fort Worth, TXBuilt 1963 · S/N 17250114 N2514XAdair Larry K Trustee · Cameron Park, CABuilt 1964 · S/N P206-0014 N2514YBargabos Julie A · Peterboro, NYBuilt 1962 · S/N 17249814 N2515CCorbett Derek B · Durham, NCBuilt 1953 · S/N 26159 N2515DCooper Gerald W · Kennewick, WABuilt 1952 · S/N 20667 N2515LClear Air Aviation LLC · Talkeetna, AKBuilt 1966 · S/N 17255715 N2515USummit Professional Business Services LLC · Grand Haven, MIBuilt 1979 · S/N 28-8016026 N2515VBoyd Robert T · Quakertown, PABuilt 1948 · S/N 18018

Back to AD 98-21-21 R1