Registered aircraft · 20,481

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.

N8279ZVines Forrest Mackenzie · Bonney Lake, WABuilt 1963 · S/N 205-0279 N827CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281271 N827DGAfrica Inland Mission International Inc · Peachtree City, GABuilt 1981 · S/N U206-06286 N827TWGardner Thomas W · Lincoln, MEBuilt 1973 · S/N 21059836 N8280ETrivedi Jay S · Skokie, ILBuilt 1984 · S/N 18268389 N8281Q9 North LLC · Parker, COBuilt 1976 · S/N U20603142 N8281ZSpearfish Aviation Inc · Summerset, SDS/N U20604116 N8283ZClear Prop LLC · Bogalusa, LAS/N 205-0283 N8285ZVaughn Hollis L · Virden, NMBuilt 1963 · S/N 205-0285 N8286M3 Jc LLC · Phoenix, AZBuilt 1970 · S/N 21059286 N8287MProfessional Metal Services Inc · Albion, NEBuilt 1970 · S/N 21059287 N8287QAdventist World Aviation · Wilson, NCBuilt 1976 · S/N U20603148 N8287ZMillion John B · Westminster, MDBuilt 1963 · S/N 205-0287 N8288MAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1970 · S/N 21059288 N828CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281272 N828LFFinseth Loren V Trustee · Fountain, MNBuilt 1977 · S/N 18265438 N828PBAero Missions LLC · Zeeland, MIBuilt 1977 · S/N 18265926 N828RHMad Kav Properties LLC · Corona, CABuilt 1979 · S/N 18267467 N828RJNielsen Ron E · Lindon, UTS/N 21063836 N828SGSky High Aviation Of Ga LLC · Doraville, GABuilt 2012 · S/N 18282325 N8291MElbs Aviation LLC · Pell City, ALBuilt 1976 · S/N 18264581 N8292MAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 21059292 N8292SStephens Ralph W · Reno, NVBuilt 1964 · S/N 18255792 N8292ZBenedick Yachal O · Wilsey, KSBuilt 1963 · S/N 205-0292 N8293QBaker Marianne J · Raeford, NCBuilt 1976 · S/N U20603154 N8293ZAv8r Aviation LLC · Yakima, WABuilt 1963 · S/N 205-0293 N8297ZMartinez Gabriel M · Santa Fe, NMBuilt 1963 · S/N 205-0297 N829CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281263 N829FACareer Flight Training And Aircraft Rental Holding · Naples, FLBuilt 2002 · S/N 18281129 N829TJJ T Airshows · Slidell, TXBuilt 1953 · S/N 16048 N82ADAdams Aircraft LLC · Wilmington, DEBuilt 1961 · S/N 18253753 N82BAMcilnay Brian S · Athens, TNBuilt 1981 · S/N 18268084 N82BGGrimshaw Brian Trustee · Long Beach, CABuilt 1964 · S/N 18255427 N82CCDenrow Limited Lc · Shawnee, OKBuilt 1975 · S/N 18264066 N82CTCoelho Gabriel P · Chowchilla, CABuilt 1969 · S/N 18259804 N82DZJosephine Air LLC · Castle Rock, WABuilt 1978 · S/N 18266752 N82ERMidwest Airmotive Inc · Mount Sterling, KYBuilt 1978 · S/N R18200225 N82FBBolea Air Inc · Morgan Hill, CABuilt 1974 · S/N 18263094 N82FLVan Bortel Aircraft Inc · Arlington, TXBuilt 2001 · S/N 18281007 N82HSAdventist World Aviation · Wilson, NCBuilt 1971 · S/N 18260814 N82JDJ D Aviation LLC · Rochester, NYBuilt 2018 · S/N 18283040 N82JWGaines Joseph M · Niceville, FLBuilt 1980 · S/N 18053162 N82KCDrake Raymond H · Asheville, NCBuilt 1998 · S/N 18280193 N82KYKentucky Department Of Aviation · Frankfort, KYS/N 18267092 N82LAAvery Lyle · Beach Lake, PABuilt 2000 · S/N 18280846 N82LECollier County Sheriffs Office · Naples, FLBuilt 2004 · S/N 18281377 N82LWMuskox Ministries · Fairbanks, AKBuilt 1973 · S/N U20602054 N82MEHutt George H III · Stratham, NHBuilt 1975 · S/N 18264089 N82NGallant James II · Scottsville, KYS/N 33538 N82NACoduto Billy Mark · Shelbyville, TNS/N 18264607

Back to AD 84-10-01 R1