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.

N27527N27527 LLC · Florence, SCBuilt 1977 · S/N 31-7852044 N27528Seacrest Seven LLC · Savannah, GABuilt 1977 · S/N 31-7852045 N2752DShapiro Sara · Olympia, WABuilt 1952 · S/N 25294 N2752FSchoppaul David · Anthem, AZFirst renewal noticeBuilt 1965 · S/N 18256852 N2752GZambarano Matthew C · South Hero, VTBuilt 1959 · S/N 52052 N2752QAnspaugh Bruce E Trustee · La Crescenta, CABuilt 1967 · S/N 18257952 N2752WL Deckard Aviation Ministries · Waller, TXS/N 1167 N27532Shadow Aviation Inc · Fairbanks, AKBuilt 1979 · S/N 18503688 N2753AThomas Dale A · Gooding, IDBuilt 1969 · S/N D-9052 N2753LMccartney Matthew T · Lake Tapps, WAS/N 17255953 N2753QFull Throttle Aviation LLC · Terlingua, TXS/N 18257953 N2753WGleaton Marcus H · Weatherford, TXBuilt 1966 · S/N 3349 N2753XStorer Charles E · Payette, IDBuilt 1965 · S/N 18051553 N2754EGulf Coast Helicopters Inc · Pearland, TXBuilt 1978 · S/N 17271315 N2754FOtter Mark E · Warrensburg, MOBuilt 1965 · S/N 18256854 N2754LThompson John D · Amana, IABuilt 1967 · S/N 17255954 N2754UKirkpatrick Dan C · Little Rock, ARBuilt 1963 · S/N 17250354 N2754VSheldon Paul T · Saint James, MNS/N D-139 N27550Anderson Herman A · Basalt, COBuilt 1967 · S/N D-8465 N2755CR & B Aviation LLC · Oakland, MIBuilt 1955 · S/N 31902 N2755GOnderdonk Allyn K · Mills River, NCBuilt 1957 · S/N 57-6043 N2755QBlessed With Wings LLC · Queen Creek, AZS/N 18257955 N2755WEast Rick · Muscle Shoals, ALFirst renewal noticeBuilt 1966 · S/N 1047 N2755XMcsheehy James B · Fallbrook, CABuilt 1965 · S/N 18051555 N2755YNancy Aviation LLC · Fayston, VTBuilt 1958 · S/N TD-106 N27562Montcalm-Mcdonald LLC · Mansfield, LABuilt 1978 · S/N 31-7812050 N2756DStewart James A · San Ramon, CABuilt 1952 · S/N 25298 N2756JSquatch Air LLC · Wasilla, AKBuilt 1969 · S/N 185-1506 N2756QLett Brian R · Eden Prairie, MNBuilt 1967 · S/N 18257956 N2756WJohnson Stephen C · Lake Tapps, WABuilt 1966 · S/N 1048 N2757FNationwide Web Directory Ltd · Seattle, WABuilt 1965 · S/N 18256857 N2757QFive Seven Quebec Incorporated · Lake Stevens, WABuilt 1967 · S/N 18257957 N2757UUt Lightsport One LLC · Uintah, UTBuilt 1963 · S/N 17250357 N2757WDennis Christopher A · Richardson, TXBuilt 1966 · S/N 1049 N2758Panair Flying Club Inc · Miami, FLBuilt 1975 · S/N 17265168 N2758QDayton Stephen · Littleton, NHBuilt 1977 · S/N 32R-7780264 N2758TLinn Anthony B · Westborough, MABuilt 1967 · S/N TE-367 N2758XAerotechniques LLC · South Kent, CTBuilt 1965 · S/N 18051558 N2759CHillegeist Tracy L · Beverly, KSBuilt 1954 · S/N 26303 N2759RFord William(Bill) A III · Abilene, TXBuilt 1969 · S/N 28R-35284 N2759TLopas Jon D Trustee · Prescott, AZBuilt 1967 · S/N D-8468 N2759WBar F Aviation LLC · Scottsbluff, NES/N 3352 N275AMAerodynamic LLC · Aurora, ORBuilt 2022 · S/N 2881518 N275BBrunsvold Gene R · Selma, ORBuilt 1970 · S/N D-9206 N275BMWestchester Flying Club Inc · Purchase, NYBuilt 1966 · S/N D-8196 N275CBCalifornia Baptist University · Riverside, CABuilt 2025 · S/N 2881916 N275CFFlyers Of The Americas Pr LLC · Guaynabo, PRS/N 318252017 N275CTInfinity Real Estate LLC · Guaynabo, PRBuilt 1979 · S/N 318052019 N275DMMaxfield Douglas R · Chico, CABuilt 1975 · S/N 18052558 N275DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010075

Back to AD 98-21-21 R1