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.

N11HHRegistration Pending · Durango, CORegistration pendingBuilt 1965 · S/N 18051484 N11JESky Vista LLC · Macon, GABuilt 1974 · S/N 18263240 N11KRDawson Gray N · Roseburg, ORBuilt 1976 · S/N 21061249 N11LATwo-Ten LLC · Ramona, CABuilt 1968 · S/N 21059058 N11RSager Timothy P · Tullahoma, TNBuilt 1952 · S/N 7765 N11TCShiver James B Jr · Stanley, NMBuilt 1977 · S/N 21062230 N11VYPritt Brian C · San Luis Obispo, CABuilt 1979 · S/N 18267086 N11WHT T Aero LLC · Pauls Valley, OKBuilt 1956 · S/N 33447 N11YJCrawley Frederick J · Virginia City, NVS/N 182-66498 N11YZHuggins David R · Carmichael, CABuilt 1970 · S/N 18260401 N12000Bear Creek Air LLC · Helena, MTBuilt 1968 · S/N 18259487 N1205BEngel Shane J · Willow, AKBuilt 1963 · S/N 205-0190 N12077Crawley Michael P · Penn Valley, CABuilt 1965 · S/N 18255966 N1209MShook Steve Trustee · Boulder, COBuilt 1975 · S/N 18264243 N120GRStarlight Flight Aerial Tours LLC · Coppell, TXBuilt 1999 · S/N 18280430 N120HPRegistration Pending · Lawton, OKRegistration pendingBuilt 2006 · S/N 18281841 N120JHC&C Cessna LLC · Baltimore, MDBuilt 1977 · S/N U20603636 N120WEHarbor Air Inc · Ann Arbor, MIBuilt 2002 · S/N 18281117 N1213LBlack Jesse M Jr · Gainesville, GABuilt 1969 · S/N 18259551 N1215MBieber Dale E · Coralville, IABuilt 1977 · S/N 21061924 N1216MHayward Flying Club · Hayward, CABuilt 1975 · S/N 18264245 N1219GRegistered aircraftBuilt 2007 · S/N 18281886 N1219PJersey Christopher M · Willis, TXBuilt 1977 · S/N 18265701 N121CEAdvanced Flight Instruction LLC · Greenwood, DEBuilt 1974 · S/N 21060503 N121EMRegistration Pending · Austin, TXRegistration pendingBuilt 1966 · S/N 18257784 N121FHamilton Wayne J · Mesa, AZBuilt 1956 · S/N 32353 N121JMBullet Aviation LLC · Missoula, MTBuilt 2025 · S/N 18283317 N121JRKlotz Geoffrey B · Moor Park, CABuilt 1977 · S/N 21061726 N121KSCa-C180j LLC · Addison, TXBuilt 1976 · S/N 18052683 N121LLWild Blue Air LLC · Homer, AKBuilt 1977 · S/N U20603756 N121MTc-Craft Aero Club Inc · Nampa, IDBuilt 1977 · S/N 18265624 N121RAJohnson Owen M III · Seattle, WABuilt 1972 · S/N 18261660 N121RDVickery Forest H · Tallahassee, FLS/N 18052053 N121RJCessna 121 Rj LLC · Terra Bella, CABuilt 1972 · S/N 21059735 N1220CSky Bear Aviation LLC · Wilmington, DEBuilt 1956 · S/N 33008 N1220GGastrock Robert C Trustee · Anchorage, AKBuilt 1973 · S/N U20602232 N1220MMcginty Flying Service LLC · Jones, LABuilt 1975 · S/N 18264246 N1220RKeywestaero LLC · Wilmington, DEBuilt 2005 · S/N 18281582 N12222Thomas John S · Starkville, MSBuilt 2007 · S/N 18282003 N1224PM3 West Inc · Modesto, CABuilt 2004 · S/N 18281357 N1228MHillsboro Flying Club · Hillsboro, ORBuilt 1975 · S/N 18264247 N122DTFine Point Aviation LLC · Carrollton, GABuilt 2000 · S/N 18280908 N122FSiver Creek Capital LLC · Emery, SDS/N 21058967 N122JAChase James P · Waco, TXBuilt 2025 · S/N 18283320 N122JSGraham Design Services Inc · Dawsonville, GABuilt 1979 · S/N 18266866 N122MWWalker Kyle E · Lawrence, KSBuilt 1979 · S/N R18201276 N122RCCurtis Alvis Jr · Bakersfield, CAS/N 21059298 N122TGAnzalone Donald Michael · Durango, COBuilt 1980 · S/N 18267533 N122TTEveraert Filip L · Midland, MIBuilt 1974 · S/N 18262858 N122WTStoimenov Kirill H · San Andreas, CABuilt 1977 · S/N 18266094

Back to AD 84-10-01 R1