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.

N176ERSkywarrior Flight Training LLC · Pensacola, FLS/N 17269507 N176JBDecatur Aero Club Inc · Decatur, ILBuilt 1998 · S/N 2843183 N176LFFour Basics LLC · Olathe, KSBuilt 1977 · S/N E-1052 N176LLClear Above LLC · Haymarket, VABuilt 1975 · S/N 21061135 N176MMRair Air Inc · Stateline, NVBuilt 1976 · S/N 310R0710 N176STCp A36 Inc · Knoxville, TNBuilt 1976 · S/N E-884 N176TCRedtail Cirrus LLC · Boise, IDBuilt 1979 · S/N 18503814 N176VBGraystoke Aviation LLC · Shepherd, MTBuilt 1976 · S/N D-9926 N176VTNewberg Andrew J · Clinton, ILBuilt 1976 · S/N 32R-7680279 N176WHarwell Evin Dtrustee · Howell, MIBuilt 1978 · S/N E-1335 N176WBVincent David R · Hartley, TXBuilt 1976 · S/N 32-7600013 N176XClub Turbo 176 LLC · Santa Clara, CABuilt 1976 · S/N E868 N176YCessna U206f Aviation LLC · Boise, IDS/N U206-03383 N177Executive Travel Authority LLC · Wilmington, DEBuilt 1970 · S/N 27-4511 N17702Bosley Blake R · Richmond, TXBuilt 1977 · S/N CE-701 N17703Dakota Aviation LLC · Sioux Falls, SDBuilt 1977 · S/N E-1007 N17704Hall Thomas N · Dothan, ALBuilt 1977 · S/N E-1008 N1770GJansen David C · Warm Springs, GABuilt 1962 · S/N TC-294 N1770RRegistered aircraftBuilt 1974 · S/N 18502490 N1770TCherryhill Aviation Inc · Freetown, INBuilt 1971 · S/N 28-7125385 N1770XPark Avenue Group Inc · Stuart, FLBuilt 1975 · S/N 21060791 N17718Katzakian Philip O · Lodi, CABuilt 1977 · S/N D-9998 N1771MGaley Matthew Blake · Greenwood, MSBuilt 1975 · S/N 18264433 N17722International Jets Inc · Gig Harbor, WABuilt 1977 · S/N TC-2045 N17726Air Commander LLC · Woodbury, MNBuilt 1977 · S/N TC-2046 N1772FTia Aviation LLC · Hot Springs, ARBuilt 1966 · S/N 17255167 N1772JCope Parrish B · Lemoore, CABuilt 1968 · S/N 28-24194 N1772WRichland Flight Academy LLC · Sidney, MTBuilt 1972 · S/N E-377 N17732Wright Brian L · Franklin, TNBuilt 1977 · S/N TE-1102 N17735Stoppelbein Colby · Kenansville, NCBuilt 1977 · S/N CE-703 N17738Lambert Michael C · San Jose, CABuilt 1977 · S/N CE-702 N1773DReeves Stephen E · Palm Harbor, FLBuilt 1951 · S/N 20216 N1773FRegistration Pending · Jasper, ALRegistration pendingBuilt 1966 · S/N 17255168 N1773RAsher Robert P · Oregon City, ORBuilt 1978 · S/N R18200554 N1773WWade William C Trustee · Cottonwood, AZBuilt 1972 · S/N D-9413 N17746Hansen Christopher Smith Sr · Surf City, NCBuilt 1977 · S/N D-10003 N17747Davis 180 LLC · Baton Rouge, LABuilt 1977 · S/N CE-704 N17748Montineri Joseph A · Port Orange, FLBuilt 1977 · S/N E-1017 N1774CStol LLC · Fort Wayne, INBuilt 1953 · S/N 30474 N1774FBarnstormers Aero Services Inc · Lompoc, CABuilt 1966 · S/N 17255169 N1774HPeacock Bruce M · Mendon, VTBuilt 1980 · S/N 18267507 N1774VAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263747 N17751Brewer Bret D · Woodward, OKBuilt 1977 · S/N D-10004 N1775MN1775m LLC · Taos, NMBuilt 1950 · S/N D-2283 N1775RAnderson Lenny R · King Salmon, AKBuilt 1974 · S/N 18502494 N17762Hightower Group Holdings LLC · Dallas, TXBuilt 1982 · S/N 28-8390023 N17763Kahanek Sylvester S · Deer Park, TXBuilt 1979 · S/N 28-8090179 N17764N17764 LLC · Quincy, WABuilt 1977 · S/N E-1021 N17766Elworthy Steven M · Huntington Beach, CABuilt 1977 · S/N E-1023 N17769Jmk Engineering Inc · Bloomfield Hills, MIBuilt 1977 · S/N E-1027

Back to AD 98-21-21 R1