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.

N9496MRegistered aircraftBuilt 1970 · S/N 21059396 N9496THudson Willis C · Hendersonville, NCBuilt 1960 · S/N 57296 N9496XPaz Nicolas · La Verne, CABuilt 1961 · S/N 21057796 N9497EAivcon Inc · Charlevoix, MIBuilt 1984 · S/N 18268420 N9497MJomama Aviation LLC · Kalispell, MTBuilt 1970 · S/N 21059397 N94986United States Air Force (Owner) · Usaf Academy, COBuilt 1978 · S/N 18266552 N9498EBowker Neal H · Tucson, AZS/N 18263915 N9498MVoorhies Jon · Atascadero, CABuilt 1970 · S/N 21059398 N9498YRamsgate Ltd · Sedalia, COBuilt 1981 · S/N 21064522 N94992Mac Air Corp · Benton, KSBuilt 2013 · S/N 18282359 N94993Meyer Michael S · Marietta, GABuilt 1978 · S/N 18266556 N9499GT F T LLC · Hayden, IDBuilt 1971 · S/N U20601699 N9499XCovalt Justin D · Arcadia, OKBuilt 1961 · S/N 21057799 N9499YMilhouse Richard J · Aguila, AZBuilt 1981 · S/N 21064523 N9499ZDark Sky Enterprises LLC · Flagstaff, AZBuilt 1998 · S/N 18280292 N949CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 18283128 N949LHappy Mangos LLC · Anchorage, AKBuilt 1982 · S/N U20606639 N949MDUnruh Leasing LLC · Blossom, TXBuilt 1973 · S/N 21059889 N949SFRasmussen Agribusiness Inc · Antelope, MTBuilt 1979 · S/N 21063515 N949VWCates Byron S · Ronan, MTBuilt 1967 · S/N 18258156 N94AZGulf Coast Helicopters Inc · Pearland, TXBuilt 1985 · S/N 18268534 N94BCChapman Air LLC · Plain City, OHBuilt 1978 · S/N 18266510 N94EJCamp Gerald M · Murrieta, CABuilt 1978 · S/N 18266342 N94ELCehula James Douglas · Anchorage, AKBuilt 1977 · S/N U20604131 N94HDFreed Philip B · Parkland, FLBuilt 1965 · S/N 18256368 N94LSPalms Property Management Inc · Heber City, UTBuilt 1973 · S/N 18262356 N94MNVista Aviation Inc · Pacoima, CABuilt 1985 · S/N 18268481 N94MPMissouri State Highway Patrol · Jefferson City, MOBuilt 1998 · S/N 18280271 N94NMSykes Gregory P · Arlington, WABuilt 1974 · S/N U20602336 N9500XSky Med LLC · Vinton, LABuilt 1961 · S/N 21057800 N9501TNeverland Air Co LLC · Myerstown, PABuilt 1960 · S/N 57301 N9501XFlowers Bobby J · Parksley, VABuilt 1961 · S/N 21057801 N9502TSilveria Michael J · Soledad, CABuilt 1960 · S/N 57302 N9502YBci Aviation LLC · Arroyo Grande, CABuilt 1981 · S/N 21064525 N9503QGulf Coast Helicopters Inc · Pearland, TXS/N 18280075 N9503YRoss Carl D · Arbuckle, CABuilt 1998 · S/N 18280215 N9504BVan Winkle Randy M · Van Buren, MOBuilt 1957 · S/N 32801 N9504LTaylor William C · Portsmouth, NHBuilt 1998 · S/N 18280210 N9506WAttitude Aviation Inc · Livermore, CABuilt 1997 · S/N 18280110 N9506XBradshaw Aviation Systems LLC · Bridgeton, MOBuilt 1985 · S/N 18268541 N9507BHanderson Ronald Jr Sr · Sitka, AKBuilt 1957 · S/N 32804 N9509TKline John C · Wolcottville, INS/N 57309 N9509XHilliard Keith B · Van, TXFirst renewal noticeBuilt 1961 · S/N 21057809 N950CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282185 N950HPKansas Highway Patrol · Topeka, KSBuilt 1998 · S/N 20608002 N950SRAcme Aero LLC · Kingman, KSBuilt 1979 · S/N 21063698 N9510XWillett Michael J · North Little Rock, ARBuilt 1961 · S/N 21057810 N9511BRadford Kenneth J Jr · Chugiak, AKBuilt 1957 · S/N 32808 N9511GBurdette Ernest L · Pass Christian, MSBuilt 1998 · S/N 18280121 N9511RBrewer William B · Fairbanks, AKBuilt 1985 · S/N U20606881

Back to AD 84-10-01 R1