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.

N8188ZHzl Hanger LLC · Drums, PABuilt 1963 · S/N 205-0188 N8189GBeebe Brad A · Clinton, MOBuilt 1974 · S/N 18263341 N8189ZMirage Mfg Co Inc · Gainesville, FLBuilt 1962 · S/N 205-0189 N818ARLandsworth Corp · Monterey, CABuilt 2004 · S/N 18281430 N818CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281258 N818HFlorez Oscar · Independence, KSBuilt 1958 · S/N 51548 N8191GGroce James D · Portland, ORS/N 18263343 N8196MEmry Kent · Salem, ORBuilt 1976 · S/N 18264560 N8196ZMahaney James G · Tahlequah, OKBuilt 1963 · S/N 205-0196 N8197GDeason Warren Douglas · Marietta, GABuilt 1974 · S/N 18263349 N8198GSky Wagon LLC · Phoenix, AZS/N U20603778 N8199QTb Aviation LLC · Waukee, IABuilt 1975 · S/N 18263870 N8199ZParker Wesley A · Cookeville, TNBuilt 1963 · S/N 205-0199 N819CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281259 N819DGPadrew LLC · Fort Lauderdale, FLBuilt 1978 · S/N 18266759 N819PSWoodard William R · University Place, WABuilt 2003 · S/N 18281241 N81APBearcat Aero LLC · Cleburne, TXBuilt 1976 · S/N 18265040 N81CMBrothers Holdings LLC · Waterford, MIBuilt 1971 · S/N 18260721 N81DStephen Jones · Roach, MOBuilt 2023 · S/N 18283239 N81DTKbk Aviation LLC · Youngsville, LAS/N 21064519 N81HDSkytte Christian · Wichita, KSBuilt 1963 · S/N 18254900 N81KCCraigo Keith A · Addison, TXBuilt 1981 · S/N 21064386 N81LBGaravaglia Gary E · Statesville, NCBuilt 2001 · S/N 18281042 N81LTDob Air LLC · Baiting Hollow, NYBuilt 1958 · S/N 51547 N81MPPatriot Aviation Inc · Greenville, DEBuilt 1985 · S/N 18268520 N81SCGl Aircraft Enterprise LLC · Wilmington, DEBuilt 1970 · S/N 21059382 N81TJHelgerson Nicky A · Zwingle, IABuilt 1964 · S/N 18255385 N81TPPowers Charles M · Greenwood, MSBuilt 1979 · S/N 210-63426 N81ZHCarlsbad Raceway Corp · Hemet, CABuilt 1978 · S/N 21062541 N8202VCebulski Barry A · Fairbanks, AKBuilt 1966 · S/N 18051704 N8203KHandy Air Inc · Douglas, GABuilt 2004 · S/N 20608203 N8203MBottle Meister Inc · San Luis Obispo, CABuilt 1969 · S/N 21059203 N8204ZLfs Inc · Ekalaka, MTFirst renewal noticeBuilt 1963 · S/N 205-0204 N8205ZMcdaniel George C · Mission Viejo, CABuilt 1963 · S/N 205-0205 N8206MMaxon William D · Santa Paula, CABuilt 1976 · S/N 18264563 N8206VRegistration Pending · Wasilla, AKRegistration pendingBuilt 1966 · S/N 18051708 N8206ZMadson Barry L · Dayton, NVBuilt 1963 · S/N 205-0206 N8207MMurphy Robert A · Kent, WABuilt 1976 · S/N 18264564 N8208VSamalon William S Trustee · Juneau, AKBuilt 1966 · S/N 18051710 N8209UWrangell Mountain Air Inc · Palmer, AKBuilt 1961 · S/N 185-0213 N820AHBuffaloe Thomas N · Mancos, COBuilt 1981 · S/N U20606123 N820AKMabry Monte D · Anchorage, AKBuilt 1977 · S/N 18052892 N820APApe Aviation LLC · Morgantown, WVBuilt 2024 · S/N 18283251 N820BTJjsap Holdings LLC · Kalispell, MTBuilt 2005 · S/N 18281574 N820CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281260 N820CRCeal Company LLC · Long Beach, CABuilt 1977 · S/N 18265561 N820KECannery Leasing Ltd · Friday Harbor, WABuilt 2007 · S/N 18281884 N820SSFloyd Air LLC · Searcy, ARBuilt 2000 · S/N 18280701 N8210MPeavy Magnus Delacy IV · Crawfordville, FLBuilt 1969 · S/N 21059210 N8212ZJms Aviation LLC · Waynesville, OHS/N 205-0212

Back to AD 84-10-01 R1