Registered aircraft · 40,471

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') 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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N91631Seale Taylor Edward · Madison, WIBuilt 1993 · S/N 2890177 N91634Tharp Anthony W · Charleston, WVBuilt 1993 · S/N 2890178 N9163DRubbert Jan Dale · Upham, NDBuilt 1958 · S/N 22-6216 N9163JCavu Flight Training LLC · Freeport, MEBuilt 1966 · S/N 28-3222 N9163ZPray Aviation Inc · Augusta, KSBuilt 1989 · S/N 2841056 N9164JArizona Airbourne LLC · Gilbert, AZBuilt 1966 · S/N 28-3224 N9164VMccurry Larry A · Double Oak, TXBuilt 1969 · S/N 690031 N9165DNelson Vanessa Jump Trustee · Portland, ORBuilt 1958 · S/N 22-6218 N9165KCasey Matthey J · Sedalia, COBuilt 1989 · S/N 2890104 N9165SHufford Christopher · Tucson, AZBuilt 1976 · S/N M-1779 N9166JRed Rock Flying School LLC · Mesa, AZBuilt 1966 · S/N 28-3226 N9166LSutton Aircraft Salvage LLC · Palmer, AKBuilt 1972 · S/N 319-72 N9166SHarris Douglas H · Morgan, UTBuilt 1976 · S/N M-1780 N9166TBoling Scott D · Idaho Falls, IDBuilt 1979 · S/N 18-7909065 N91673Martin Charles W · Twain Harte, CABuilt 1973 · S/N 17261506 N9167SContinental Aviation Club Inc · Lincoln, VABuilt 1976 · S/N M-1781 N9167VChapman William Herbert · Dayton, OHBuilt 1969 · S/N 690015 N9168J2binc LLC · Adrian, MIBuilt 1966 · S/N 28-3229 N9168LMoore Jon · Chuckey, TNBuilt 2003 · S/N 20812 N9168QPhillipson Justin M · Vacaville, CABuilt 2001 · S/N 1167 N9169DLapaseotes George P II · Sidney, NEBuilt 1958 · S/N 22-6222 N9169LSimons Grant C · White Owl, SDBuilt 1971 · S/N 320-72 N9169RDye Rodney D · Marietta, OHBuilt 2003 · S/N D0101 N9169THayes George F · Friendsville, PABuilt 1979 · S/N 18-8009012 N916ATKdrd Holdings LLC · Texas City, TXBuilt 1982 · S/N 17275931 N916AVLopez Virgilio D · Brookshire, TXS/N 17272800 N916BNAir Care Leasing LLC · Lamar, COBuilt 1998 · S/N 21085 N916CLDolphin Sales Inc · Wilkes Barre, PABuilt 1975 · S/N 17702273 N916HPNeustaeter Pedro Thiessen · Anthony, NMS/N 28-2658 N916JFHammett Gary N · Prince Frederick, MDBuilt 1974 · S/N 28-7405130 N916KSmith Brandon D · Laguna Beach, CABuilt 2005 · S/N 001 N916MHHelmerich Jonathan D Jr · Tulsa, OKBuilt 1969 · S/N 17258177 N916PYBragg Kris M · Embden, MEBuilt 1968 · S/N 17257159 N916RDUssery Donald R · Blytheville, ARS/N 23-1743 N916SEEiland James · Phenix City, ALBuilt 1977 · S/N 17269640 N916TTReyes-Hernandez Jose R · San Juan, PRBuilt 1989 · S/N 2841146 N916YEggimann William W Trustee · Anchorage, AKBuilt 1973 · S/N 18-7309023 N9170DSmith Glen R · Tracy, MNBuilt 1958 · S/N 22-6224 N9170SLee Benjamin W Trustee · Chandler, AZBuilt 1976 · S/N M-1783 N9170VMitchell Kevin L · Glen Saint Mary, FLBuilt 1969 · S/N 690032 N9171DJensen Timothy G · Junction City, ORBuilt 1958 · S/N 22-6226 N9171HSonday Terrance · Spring, TXBuilt 1975 · S/N 17265990 N9171JRichardson Adam D · Franklin, INBuilt 1966 · S/N 28-3232 N9172SShuffield Brian D · Oregon House, CAS/N M-1793 N9172YMohammadreza Sabzi · Los Angeles, CABuilt 1985 · S/N 28-8616034 N9173HSmitty 172 LLC · Rockford, MIBuilt 1975 · S/N 17265992 N9173XLinzel Jesse G Jr · Southern Pines, NCBuilt 1996 · S/N 11-176 N9174JOrleans Flying Club Inc · Orleans, INBuilt 1966 · S/N 28-3238 N9174MParis Air Inc · Vero Beach, FLBuilt 1985 · S/N 28-8616035 N9174TPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 18-8009013

Back to AD 80-04-03 R2