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.

N96923Green David C · Milford, IABuilt 1979 · S/N 18266896 N96928Jurkowski Raymond · Germantown, NYBuilt 1979 · S/N 18266897 N96929Ware Joseph B · Angleton, TXBuilt 1979 · S/N 18266898 N9692THarbaugh Eric M · Russell, KSS/N 57492 N9692YA Viation Inc · Bennettsville, SCS/N 21064574 N96943Porta Michael W · Old Bridge, NJBuilt 1979 · S/N 18266904 N96949Pittman William Greg · Anchorage, AKBuilt 1979 · S/N 18266908 N9694TGarza Gilberto · Yuma, AZS/N 57494 N9694XDawson Timothy E · Dahlonega, GAS/N 21057994 N96952Gospel Ministries International · Collegedale, TNBuilt 1979 · S/N 18266909 N9695XHam Robert · El Cajon, CABuilt 1962 · S/N 21057995 N96968Shaw Stephen A · Sherwood, ORBuilt 1979 · S/N 18266918 N9696FShakman Michael L Trustee · Chicago, ILBuilt 1998 · S/N 18280269 N9696TJ & F Aviation Adventure LLC · North Fort Myers, FLBuilt 1960 · S/N 57496 N96977Couch Christopher · Huntertown, INBuilt 1979 · S/N 18266921 N96988Wenner Aaron · Tehachapi, CABuilt 1979 · S/N 18266925 N9698EPark Rapids Avionics Inc · Park Rapids, MNBuilt 1984 · S/N 18268438 N9698GCash Jeffery Scott · Gresham, ORBuilt 1977 · S/N U20603826 N96991Johnson Kirk · Klamath Falls, ORBuilt 1979 · S/N 18266928 N9699GCruikshank Brian S · Portland, ORBuilt 1974 · S/N 18263434 N9699TBas Part Sales LLC · Greeley, COS/N 57499 N969KMSk Aircraft LLC · Anchorage, AKBuilt 1961 · S/N 185-0024 N969RBK Fortner LLC · San Marcos, TXBuilt 1968 · S/N U206-1061 N969RM182 LLC · Battle Ground, WABuilt 1974 · S/N 18263050 N969SBBostyancic Stanley J · Cohasset, MNBuilt 1975 · S/N U20602724 N969SLWojcik Bart C · Kimberly, IDBuilt 1975 · S/N 21060915 N969WMCrank Kim · Little Rock, ARBuilt 1962 · S/N 1850506 N96ACaldwell Mark K · Bunker Hill, INBuilt 1950 · S/N 7500 N96AKRenfro Michael W · Bethel, AKBuilt 1984 · S/N 20700782 N96CCInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 21062787 N96CNNearburg Charles E · Creede, COBuilt 1979 · S/N 18266868 N96LGTaildragger LLC · San Ramon, CABuilt 1965 · S/N 18051517 N96LLHuck-Mag LLC · Plano, TXBuilt 1974 · S/N 21060361 N96SJCavender Rick · Yorba Linda, CABuilt 1979 · S/N 18266888 N96TGCampana Aviation LLC · George West, TXBuilt 2000 · S/N 18280802 N96TYAerospace Trust Management LLC Trustee · Wilmington, DES/N 18283361 N96WPVanneman William M · Ludlow, VTBuilt 1978 · S/N R182-00216 N97004Yogi Air LLC · Medina, OHBuilt 1979 · S/N 18266932 N97007Tindle Robert Brian · Waco, TXBuilt 1979 · S/N 18266933 N9700JCrux Logistics & Consulting Ltd · Las Vegas, NVBuilt 1981 · S/N T18803840T N9700ZHubbard Tyler · Atlanta, GABuilt 1982 · S/N U20606613 N97012Debourbon Michael · Pikeville, KYBuilt 1979 · S/N 18266935 N97018Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 18266936 N97021Bcks Aviation LLC · Kiefer, OKBuilt 1979 · S/N 18266938 N97024Alton Parts Supply Inc · Cottage Hills, ILS/N 18266941 N9702GZulu LLC · Blaine, MNBuilt 1971 · S/N 18052202 N9702XPilot Mountain Aviation LLC · Pilot Mountain, NCBuilt 1962 · S/N 21058002 N9703XSalsa De Tomate Inc · Craig, COS/N 21058003 N97041Paine Bruce G · Brainerd, MNBuilt 1979 · S/N 18266949 N97042Bid Systems LLC · Huntsville, ALBuilt 1979 · S/N 18266950

Back to AD 84-10-01 R1