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.

N1782DRegistration Pending · Homer, AKRegistration pendingS/N 20350 N1782FCfi Care Inc · Woodbury, CTS/N 17255177 N1782GJts Aircraft LLC · Rock Hill, SCBuilt 1962 · S/N CD-510 N1782URbr Aircraft Inc · Albuquerque, NMS/N 21064744 N17832Arrow Inc · Mount Sterling, KYBuilt 1977 · S/N E-1039 N17833Mccall Edmund B · Portland, ORBuilt 1977 · S/N TH-827 N17836Bear Dorvin L · Elida, OHBuilt 1977 · S/N E-1041 N17838N17838 LLC · Scottsdale, AZBuilt 1977 · S/N E-1046 N1783GHarrington Perry J · Carlsbad, CABuilt 1962 · S/N CD-521 N1783HRegistration Pending · Anchor Point, AKRegistration pendingBuilt 1959 · S/N 35883 N1783MRyan Jason P · San Francisco, CABuilt 1975 · S/N 18264443 N17840Es Investments LLC · Chandler, AZS/N D-10017 N17846Stalford Tom G · Nicholson, PABuilt 1977 · S/N CE-714 N1784EHigh Road Time LLC · West Palm Beach, FLBuilt 1979 · S/N 310R1574 N1784FTompkins Wyatt · Pearland, TXBuilt 1966 · S/N 17255179 N1784JHelms Franklin E · Camden, ALBuilt 1968 · S/N 28-24207 N1784MWhitledge Aviation LLC · Princeton, INBuilt 1975 · S/N 18264444 N1784RCunning Aviation LLC · La Mesa, CABuilt 1978 · S/N R18200558 N1784TRegistration Pending · Detroit Lakes, MNRegistration pendingBuilt 1970 · S/N 28-7125099 N17850Copeland Kenneth E · Rosie, ARBuilt 1977 · S/N TK-58 N17852Flores Gustavo · Dallas, TXBuilt 1977 · S/N CE-715 N1785AArmstrong Edwin Alan · Atlanta, GABuilt 1969 · S/N CE-278 N1785CBorns Frederick G · Chandler, AZBuilt 1953 · S/N 30485 N1785FSale Reported · Farragut, TNSale reportedBuilt 1966 · S/N 17255180 N17863Loon Song Flyers LLC · Brookside, NJBuilt 1977 · S/N E-1055 N17865Wcs Inc · Troy, ALBuilt 1977 · S/N D-10021 N1786JGarnes Ronald O · Spokane, WABuilt 1968 · S/N 28-24209 N1786RWhalen Dann Trustee · San Diego, CABuilt 1978 · S/N R18200559 N1786TEg Aviation LLC · White Lake, MIS/N 28-7125101 N1786XS K Cattle Co · Manhattan, KSBuilt 1975 · S/N 21060806 N1787CMorris Charles W · Wasilla, AKBuilt 1953 · S/N 30487 N1787DKissel Patrick J · Anchorage, AKBuilt 1951 · S/N 20230 N1787FSchroder Robert D · Buckeye, AZBuilt 1966 · S/N 17255182 N1787JToga Aviation LLC · Glenmont, NYBuilt 1968 · S/N 28-24210 N1787TCampbell William F · Mckinney, TXBuilt 1970 · S/N 28-7125102 N1787ZWashington Arron M · Mobile, ALS/N D6464 N1788GTolbert Morgan Leslie · Bernardsville, NJBuilt 1962 · S/N D-6978 N1789Hill Sheldon S · Minot, NDFirst renewal noticeBuilt 1974 · S/N 18502342 N1789CBuxton Tracy S · Enterprise, UTBuilt 1953 · S/N 30489 N1789RPaasch Ulf · Moreno Valley, CABuilt 1971 · S/N 28-7225058 N1789TBagley Raymond G Jr · Canton, PAFirst renewal noticeBuilt 1971 · S/N 28-7125129 N178ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010055 N178EGagan Samrat LLC · Charlotte, NCS/N 30-1727 N178FVD R Tripp Enterprises LLC · Omaha, NEBuilt 1976 · S/N 17267284 N178GPanhandle Groundwater Conservation District · White Deer, TXBuilt 1980 · S/N 27-8054028 N178KASwartzentruber Robert · Oakland, MDBuilt 1971 · S/N 17260069 N178MSouth Texas Weather Modification Association · Pleasanton, TXBuilt 1979 · S/N 27-7954028 N178MCWillett Cattle Co · Sanford, COBuilt 1973 · S/N 327340178 N178QRega Consulting Inc · Port Orange, FLBuilt 1964 · S/N D-7560 N178RDHelicopter Consultants Inc · Union, WABuilt 1979 · S/N 21063445

Back to AD 98-21-21 R1