Registered aircraft · 20,486

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N151CTSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1984 · S/N 18268410 N151FCDepartment Of Agriculture And Consumer Services · Tallahassee, FLBuilt 2006 · S/N 18281874 N151MELoweth William A · Noank, CTBuilt 2000 · S/N 18280722 N151MTIsland Mountain Aviation LLC · Vesta, MNBuilt 1973 · S/N 21059861 N1521CMacdougall Glen H · Salisbury, MAS/N 30221 N1522CKruse Adam L · Weiser, IDBuilt 1953 · S/N 30222 N1523FGray Rex Lee · Palmer, AKBuilt 1965 · S/N 185-0866 N15242Bluclouds LLC · Kirkland, WABuilt 2005 · S/N 18281614 N1524DSmith Richard D II · Luthersville, GABuilt 1952 · S/N 7746 N1525DHeintz John F · Los Angeles, CABuilt 1952 · S/N 7747 N1526FRegistered aircraftBuilt 1965 · S/N 1850869 N1528DMcpartland Patrick · Herriman, UTBuilt 1952 · S/N 7750 N1529CBellows Paul F · Vancouver, WABuilt 1953 · S/N 30229 N1529FLloyd David M · Grants Pass, ORBuilt 1965 · S/N 185-0872 N152CFCharlie Fox LLC · Wilmington, DEBuilt 2002 · S/N 18281074 N152CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282335 N152MEChamp Jerry D · Belton, SCBuilt 2000 · S/N 18280723 N152PHahn Tacy W · Nevada City, CABuilt 1963 · S/N 18255080 N1530CParker Scott E · Herald, CABuilt 1953 · S/N 30230 N1530MSinclair Justin Michael · Annandale, VABuilt 1975 · S/N 18264365 N1531FWrangell Mountain Air Inc · Palmer, AKS/N 185-0874 N1532DShipman Jared K · Bismarck, MOBuilt 1952 · S/N 7754 N1533DZimmerman Luke G · Madison, ALBuilt 1952 · S/N 7755 N1534FDieckman Raymond DBA · Hamilton, MTBuilt 1965 · S/N 185-0877 N1535DHorney Paul · Russellville, ARBuilt 1952 · S/N 7757 N1537CWbs Coatings Inc · Grand Junction, COBuilt 1953 · S/N 30237 N1538DAdams Richard J · Mesa, AZS/N 7760 N1539MN1539m LLC · Kalispell, MTBuilt 1975 · S/N 18264366 N153FCDepartment Of Agriculture And Consumer Services · Tallahassee, FLBuilt 2006 · S/N 18281774 N153PPBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 18266340 N153TAAmerican Eagle 1 LLC · Kimberling City, MOBuilt 2001 · S/N 18281053 N1540MClark Robert L Jr · Johnston, IABuilt 1975 · S/N 18264367 N1541DCentral Air Service Inc · Lewistown, MTBuilt 1952 · S/N 7763 N1541FRwr Air Inc · Tok, AKBuilt 1966 · S/N 185-0896 N1542MMelgaard Kenneth William · Minot, NDBuilt 1975 · S/N 18264368 N1542UWarner Walt M · Willow, AKBuilt 1973 · S/N U20602249 N1545CGet Happy Adventures LLC · Leawood, KSBuilt 1953 · S/N 30245 N1545GSaltzer Eric R · Somerton, AZBuilt 1966 · S/N T210-0208 N1546CToney William M II · Gig Harbor, WABuilt 1953 · S/N 30246 N1547MArtman John W · Lynnwood, WABuilt 1975 · S/N 18264371 N1548CRoy Flying Service LLC · Lettsworth, LABuilt 1953 · S/N 30248 N1549CDavidson Ron · Newfolden, MNBuilt 1953 · S/N 30249 N154BCTen Knot Tailwind LLC · Mesa, AZBuilt 1969 · S/N 21059157 N154CPCivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283319 N154EFAdams Donald C · Garner, NCBuilt 1968 · S/N 21059089 N154FCDepartment Of Agriculture And Consumer Services · Tallahassee, FLBuilt 2006 · S/N 18281785 N1550CGlidden Timothy J · Millinocket, MEBuilt 1953 · S/N 30250 N1551DSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 7773 N1554CTaggart Brent W · Hydro, OKBuilt 1953 · S/N 30254 N1554FNovember 1554 Foxtrot LLC · Wilmington, DES/N 185-0921

Back to AD 84-10-01 R1