Skip to content

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.

N9838CWellman A Ryan · San Jose, CABuilt 1978 · S/N R18200458 N983AWGuthrie Robert Paul · Joiner, ARBuilt 1963 · S/N 18254914 N983VBKaufman Jeffrey Robert · Chapel Hill, NCBuilt 1978 · S/N R18200202 N9840ABrentco Aerial Patrol Inc · Canton, OHBuilt 1984 · S/N 18268409 N9840CMid Atlantic Ag LLC · Nassau, DEBuilt 1978 · S/N R18200460 N9840ELjmf17 LLC · Hayes, KSBuilt 1975 · S/N 18263926 N9841HItd Services LLC · Clarendon, TXS/N 18268062 N9841XHarms Aviation Investments LLC · Wilmington, DEBuilt 2004 · S/N 18281360 N9841YBaker Joseph M Trustee · Overland Park, KSBuilt 1981 · S/N 21064615 N9842CSale Reported · Belgrade, MTSale reportedBuilt 1978 · S/N R18200462 N9842HStewart John D · Slatington, PABuilt 1981 · S/N 18268063 N9843HAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1981 · S/N 18268064 N9843YCavu Solutions LLC · Renton, WABuilt 1981 · S/N 21064616 N9844EKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1985 · S/N 18268453 N9845HAaa Sales LLC · Apple Valley, MNBuilt 1981 · S/N 18268065 N9845XBirney John A · Arlington, WABuilt 1961 · S/N 1850045 N9846AMannen Gregory Charles II · Warren, ORBuilt 1984 · S/N 18268415 N9847ASill Phillip II · New Castle, DEBuilt 1950 · S/N 7559 N9848APearson Jeffrey W · Anaheim Hills, CABuilt 1950 · S/N 7541 N9848CBudd Richard E · Brooksville, FLBuilt 1978 · S/N R18200468 N9848HBrekke Ryan S · Edmore, NDBuilt 1981 · S/N 18268067 N9848MCovington Aircraft Engines Inc · Okmulgee, OKBuilt 1978 · S/N U20604575 N9849AWatters James · Dwight, ILBuilt 1950 · S/N 7560 N9849C377 Morale Welfare Recreational Services Aero Club · Albuquerque, NMBuilt 1978 · S/N R18200469 N9849HSouthwest Plane Holdings LLC · Kalispell, MTBuilt 1981 · S/N 18268068 N984JSFvx Research · Bristow, VABuilt 2010 · S/N 18282218 N984PDLegends Air Center LLC · Bentonville, ARBuilt 2000 · S/N 18280732 N9851ARhoads Michael C · Ketchikan, AKS/N 7561 N9851CDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N R18200470 N9851HCivil Air Patrol Inc · Montgomery, ALBuilt 1981 · S/N 18268070 N9851XWheeler Andrew C · Orting, WABuilt 1961 · S/N 185-0051 N9852CRyco LLC · Lusk, WYBuilt 1978 · S/N R18200471 N9853HMiles Alexander Bevans · Columbia, SCBuilt 1982 · S/N 18268072 N9854ASchlichar James C · Austin, TXBuilt 1952 · S/N 7547 N9854XOverly Terrence L · Tok, AKBuilt 1961 · S/N 185-0054 N9855AHawley Richard J · Moultonborough, NHBuilt 1950 · S/N 7548 N9855XMcgee Jacob Quinton · King Salmon, AKBuilt 1961 · S/N 1850055 N9857ALarson Michael D · Erie, COBuilt 1949 · S/N 7550 N9858AHolloway Donald P · Chino Hills, CABuilt 1950 · S/N 7551 N9859ASchmidt Aaron B · Auburn, ALBuilt 1950 · S/N 7552 N985DBAbidance Inc · Winthrop, WABuilt 1959 · S/N 50507 N985GWPavlik John · Portland, ORBuilt 1985 · S/N 18268535 N9861CBell Richard H · Blairsville, GABuilt 1978 · S/N R18200473 N9861YRichard I Bennett LLC · San Jose, CABuilt 1981 · S/N 21064619 N9861ZMoody Bible Institute Of Chicago · Spokane, WABuilt 1983 · S/N U20606708 N9863ACrowley John S Jr · Round Top, TXBuilt 1950 · S/N 7565 N9863EBlankinship Guy · Jackson, MSFirst renewal noticeBuilt 1985 · S/N 18268456 N9863HFrost R Edward · Winchester, ILS/N 18268079 N9864CAerowest LLC · Wilmington, DEBuilt 1978 · S/N R18200474 N9865XIrwin Flight LLC · Bellingham, WABuilt 1961 · S/N 185-0065

Back to AD 84-10-01 R1