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.

N30190N30190 LLC · Colorado Springs, COBuilt 1978 · S/N 32R-7887272 N3019AWassenaar John W · Venice, FLS/N 25663 N3019FMadison Richard Christopher · Little Rock, ARBuilt 1966 · S/N 18257119 N3019KColorado Air LLC · Colorado Springs, COBuilt 1978 · S/N 32R-7987089 N3019PNelson Matthew J · Frewsburg, NYBuilt 1957 · S/N 23-928 N3019QHatfield Brothers LLC · Gooding, IDBuilt 1967 · S/N 18258019 N3019VTimmons Mark M · New Port Richey, FLBuilt 1947 · S/N D-423 N3019YSheets Jeffrey M · Salmon, IDBuilt 1979 · S/N 28-7911148 N301ABCamber Aviator LLC · Miami, FLBuilt 1979 · S/N 34-7970186 N301AVJackson Charles A · Winchester, KYBuilt 1976 · S/N 28-7715070 N301BHTraxler Shane C · West Monroe, LABuilt 1997 · S/N 3246080 N301BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020284 N301CAFreiday Robert A · Kingman, AZBuilt 1967 · S/N 32-40178 N301CTVatm Sky Investments LLC · Thomson, GABuilt 1980 · S/N TH-1166 N301DBDon Davis Aviation Inc · Henderson, KYBuilt 1977 · S/N 310R0891 N301DDRockalong Holdings LLC · Stanton, TXBuilt 1979 · S/N 18503985 N301DPEvans Jack · Albuquerque, NMS/N 17268863 N301EBQuesnel William G · Truckee, CABuilt 1978 · S/N 21062524 N301ECF N A Aviation LLC · Wakefield, MABuilt 2025 · S/N 2881980 N301EEPacker William M III · Bloomfield Twp, MIS/N 32R-7780469 N301EMMcconwell Edward A · Mission, KSBuilt 1965 · S/N 30-916 N301GASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 18052490 N301JFGrace Eric C · Valdosta, GABuilt 1979 · S/N E-1593 N301JKKaminski John J · Torrance, CABuilt 1978 · S/N 24-0634 N301JRTropitech Inc · San Juan, PRBuilt 1973 · S/N 17261555 N301KARivard Robert M · Grand Haven, MIBuilt 1981 · S/N 32R8113020 N301KCRidl Kent S · West Fargo, NDBuilt 1978 · S/N 24-0414 N301KG217 Aviation LLC · Winchester, ILBuilt 1988 · S/N 3213017 N301KKBurris Timothy J · Fountain Inn, SCBuilt 1979 · S/N 32-7940092 N301LMN301lm LLC · Monee, ILS/N 670323 N301MCCharles Michael Maya · Erie, COBuilt 1978 · S/N 18503705 N301NDPutzke Becky A · Fort Ripley, MNS/N 17261763 N301PRussell Bill W · Victoria, TXBuilt 1978 · S/N TH-890 N301PKHubbs Matthew · Huntersville, NCBuilt 1973 · S/N 32-7440064 N301PLCutbirth David B · Monahans, TXBuilt 1966 · S/N P206-0334 N301PS3b1g Enterprises LLC · Phoenix, AZBuilt 1982 · S/N 32-8306007 N301RS2f Trade LLC · Collinsville, TXS/N 21062473 N301RTSather Dean L · Amarillo, TXBuilt 1982 · S/N 32R-8229068 N301SEAmerican Air Academy Inc · Merritt Island, FLBuilt 2004 · S/N 3449304 N301SMCameron Ottis W · Comfort, TXFirst renewal noticeBuilt 1964 · S/N 534 N301SPBeyond Air Llp · Burlington, NDS/N 24-1074 N301STTechnical Education Services Inc · Virginia Beach, VAS/N 28-25655 N301SWFly Rite Aviation LLC · Fort Myers, FLS/N 27-195 N301TCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2001 · S/N 3257257 N301TV301tv LLC · Three Lakes, WIBuilt 1982 · S/N 24-1308 N301WBBreum Sean M · Stanwood, WAS/N 25343 N3020CBrosnan Daniel · Mary Esther, FLBuilt 1958 · S/N D-5685 N3020DAllen Gregory L · Lake View, ALFirst renewal noticeBuilt 1955 · S/N 35220 N3020KGhostwriter Airshows LLC · Hustonville, KYBuilt 1978 · S/N 34-7970099 N3020MWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1979 · S/N 44-7995220

Back to AD 98-21-21 R1