Registered aircraft · 85,620

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.

N1776DRobbins Flight Training LLC · Bakersfield, CABuilt 1951 · S/N 20219 N1776JTafaghodrad Arash · Chandler, AZBuilt 1968 · S/N 28-24198 N1776TSota Charles G Jr · Kirkland, WABuilt 1970 · S/N 28-7125093 N1776URegistration Pending · Boulder City, NVRegistration pendingBuilt 1975 · S/N 32R-7680024 N1777AJohnson Ross E · Midway, UTBuilt 1979 · S/N 28-7911320 N1777CHarlan Benjamin L · Madison, KSBuilt 1967 · S/N 28-23490 N1777HFait Coleman B · Newport Beach, CABuilt 1959 · S/N 35877 N1777JHoward David Patrick · Thomasville, NCBuilt 1968 · S/N 28-24199 N1777RKnur Ronald Glen · Elizabeth City, NCBuilt 1978 · S/N R18200555 N17785Registered aircraftBuilt 1977 · S/N E-1025 N1778FBlake Brian R · Irvine, CABuilt 1966 · S/N 17255173 N1778MSeitz David C · Gordonville, TXS/N 21061958 N1778YWade Jason E · Salem, INBuilt 1966 · S/N 28-22261 N17790Tds Property Holdings LLC · Gilmer, TXBuilt 1977 · S/N TC-2055 N17791Spuza Dan D · Sanger, TXBuilt 1977 · S/N CE-708 N17794Getting Dean W · Fort Dodge, IABuilt 1977 · S/N E-1029 N17797Nieman James Lewis Jr · Alhambra, CABuilt 1977 · S/N D-10010 N1779DSchrag Jeremy M · Garden Plain, KSBuilt 1951 · S/N 20222 N1779JMidwest Aviators · Robinson, ILS/N 28-24202 N1779MBlagg Kevin · Dumas, ARBuilt 1975 · S/N 18264439 N177ABKostroski Larry J · Tucson, AZBuilt 1972 · S/N TE-873 N177CMRapid Cloud Aviation LLC · Waxhaw, NCBuilt 1978 · S/N 32R-7887273 N177DFAllen Douglas J · Fallbrook, CABuilt 1981 · S/N 32-8124022 N177DGHesperia Construction Inc DBA · Ramona, CABuilt 1979 · S/N TJ-241 N177FMeek Harvey K · Poplar Grove, ILBuilt 1964 · S/N TC-587 N177FDSale Reported · Bowling Green, KYSale reportedBuilt 1967 · S/N 680040 N177LHPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010065 N177PEPicabo Livestock Co · Picabo, IDBuilt 1979 · S/N P21000334 N177SWGruslin Jean Pol G · Kingwood, TXBuilt 1975 · S/N E-731 N177TCCaram John M · Saint Leonard, MDBuilt 1975 · S/N 221231 N177WCDittmer William R · Wheatland, NDS/N 28-7890535 N177WTBucey Barry E · Visalia, CAS/N D-6300 N177WWWallace William R · Fredericksburg, TXBuilt 1980 · S/N TC-2295 N17802Asxo · Dallas, TXBuilt 1977 · S/N CE-709 N1780MCherri Stanley · Pearland, TXBuilt 1975 · S/N 18264440 N1780RDoellefeld Jason T · Langsville, OHBuilt 1974 · S/N 18502498 N17814Sellers Scott · Solsberry, INBuilt 1978 · S/N D-10144 N17816Legal Flying Service Inc · Pembroke Pines, FLBuilt 1977 · S/N D-10011 N17817Dye Barrett · Abilene, TXBuilt 1977 · S/N E-1034 N17818Batie Gregory T · Rogers, ARBuilt 1977 · S/N CE-710 N17819Mclendon Brian · Hawkins, TXBuilt 1977 · S/N E-1035 N1781CHenkelmann David H · Janesville, WIBuilt 1953 · S/N 30481 N1781ECallaham John · Broken Bow, OKBuilt 1979 · S/N 310R1571 N1781GPinegar Aviation Services LLC · Ridgeland, SCBuilt 1962 · S/N D-6932 N1781JWeaver Dana L · Saint Joseph, MOBuilt 1968 · S/N 28-24204 N1781RDale Mar Enterprises Inc · Granton, WIBuilt 1978 · S/N R18200557 N17820Evergreen Flying Service Inc · Rayville, LABuilt 1977 · S/N TE-1101 N17826Three Six Bonita LLC · Georgetown, TXBuilt 1977 · S/N E-1036 N17827Cumins Douglas · Mechanicsville, VABuilt 1977 · S/N D-10015 N17829Slayden Wesley B · White Bluff, TNBuilt 1977 · S/N CE-712

Back to AD 98-21-21 R1