Registered aircraft · 20,483

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.

N2334CTallahassee Flying Club Inc · Tallahassee, FLBuilt 1978 · S/N R18200153 N2335FGravitte Peter F · Napa, CAS/N 21058535 N2335GRegistered aircraftBuilt 1958 · S/N 51635 N2336GLogue Elmer S · Derby, KSS/N 51636 N23383Performance Auto Body Inc · Knightdale, NCBuilt 1998 · S/N 18280406 N2338FDonnell James C · Crowville, LABuilt 1964 · S/N 21058538 N2338GIberlin Ranch · Gillette, WYBuilt 1958 · S/N 51638 N2339CSullivan Nathan · Croton, OHS/N 30639 N2339GWetzel William W · Carrizozo, NMBuilt 1958 · S/N 51639 N2339RStephens Grant A · Palmer, AKBuilt 1964 · S/N 18255439 N2339XPetet David G · Orofino, IDBuilt 1965 · S/N 18256239 N233DCMc Aviation Holdings LLC · Miami, FLBuilt 1998 · S/N 18280289 N233GSGreenville County Sheriffs Office · Greenville, SCBuilt 1972 · S/N 18261018 N233KSJean Buford Randall · Lorena, TXBuilt 1998 · S/N 18280145 N233MEEight Ball Flying Club · Van Nuys, CABuilt 2000 · S/N 18280750 N233MGFly Safe LLC · Belle Isle, FLBuilt 1980 · S/N R18201541 N233WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 18257879 N233WRVenture Alaska LLC · Homer, AKS/N U20603574 N23407S C Skylane LLC · Cumming, GABuilt 1998 · S/N 18280409 N2340CWilliam J Davis · Bismarck, NDS/N R18200155 N2340GConner Chris L · Boise, IDS/N 51640 N2340RBrandt Phillip A · Boyd, TXBuilt 1964 · S/N 18255440 N2340UTex-Pan Aviation Inc · Amarillo, TXBuilt 1982 · S/N 21064779 N2340WPienkos Kaz · Haskell, OKS/N 51743 N2341CBear Trap Enterprises Inc · Caldwell, IDBuilt 1953 · S/N 30641 N2341XYale LLC · Watford City, NDS/N 18256241 N2342CHite Donald L · Mc Kinney, TXBuilt 1953 · S/N 30642 N2342GBrodie James W · Lind, WABuilt 1959 · S/N 51642 N2342RFrisco Enterprises Inc · Califon, NJBuilt 1964 · S/N 18255442 N2342XKinsella Joseph R · Jackson, WYBuilt 1965 · S/N 18256242 N2343CStedman Bernard Warren · Anchorage, AKS/N 30643 N2343FRegistration Pending · Wickenburg, AZRegistration pendingBuilt 1964 · S/N 21058543 N2344GJones Alva L · Craig, COBuilt 1958 · S/N 51644 N2346FNavion Holdings LLC · Boise, IDBuilt 1964 · S/N 21058546 N2347RDillon John C · Flagstaff, AZBuilt 1964 · S/N 18255447 N2347XRegistered aircraftS/N 18256247 N23480Pkp Aviation LLC · Alexandria, VABuilt 1999 · S/N 18280412 N2348GWright Michael Lee · Isanti, MNBuilt 1959 · S/N 51648 N2348RMiller Robert S · Laurel Springs, NCBuilt 1964 · S/N 18255448 N2348SGeorgia Forestry Commission · Macon, GABuilt 1999 · S/N 18280411 N2348XChessman H Ross · Erie, COBuilt 1965 · S/N 18256248 N2349CSchwend Brian · Forsyth, MTBuilt 1953 · S/N 30649 N2349FMilutinovic Christain · Marengo, ILBuilt 1964 · S/N 21058549 N2349GRegistration Pending · Buckley, WARegistration pendingBuilt 1958 · S/N 51649 N2349RSalser Aviation LLC · Ocala, FLBuilt 1998 · S/N 18280413 N2349XNorris James A · Export, PABuilt 1998 · S/N 18280414 N234CMTallman Donald Depaul · Venice, FLBuilt 1966 · S/N 18257696 N234FNelson Graig M · Eastsound, WABuilt 1955 · S/N 32142 N234GTAny Border LLC · Yankton, SDBuilt 1977 · S/N 21062155 N234LPDethloff Joseph · St Johns, FLS/N 18281047

Back to AD 84-10-01 R1