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.

N2258SSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 21061202 N2258ZPope Charles A · Sandy Hook, MSBuilt 2007 · S/N 18281937 N22593State Of Nc · Raleigh, NCS/N 18281938 N2259RLarson Lianne N · Irvine, CABuilt 1968 · S/N T210-0409 N2259SFaireyfam Aviation LLC · Saint George, UTBuilt 1976 · S/N 21061203 N225EAArellano Erick · Brownsville, TXBuilt 2024 · S/N 18283273 N225FAMcclure Nicholas W · Midland, TXBuilt 2003 · S/N 18281252 N225JACoffin Paul · Sioux City, IABuilt 1979 · S/N R18201320 N225MGandiaga Philip John · Buhl, IDBuilt 1960 · S/N 52996 N225TCameron Mark · Big Arm, MTBuilt 1969 · S/N 18259960 N225TXCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 18266946 N2260EJm-Bac Holdings LLC · Arcadia, OKBuilt 2007 · S/N 18281939 N2260GJump Tn LLC · Greeneville, TNBuilt 1958 · S/N 51560 N2260SWheeler Eugene N · Livermore, CABuilt 1976 · S/N 21061204 N2260TOrtner Airport LLC · Wakeman, OHBuilt 1977 · S/N R18200012 N2261CGandy John W III · Mt Vernon, TXBuilt 1953 · S/N 30561 N2261RPetik Jason P · Sidney, NEBuilt 1968 · S/N T210-0411 N2262SKoch Phillip E · Eldon, MOBuilt 1976 · S/N 21061206 N2263CWalker William S · Shallotte, NCBuilt 1953 · S/N 30563 N2263TUnited States Air Force · Dover Afb, DEBuilt 1977 · S/N R18200014 N2264GMessner Mark R · Chesapeake, OHBuilt 1958 · S/N 51564 N22650Sackett Gary G · Millcreek, UTFirst renewal noticeBuilt 1972 · S/N 21059767 N2265GWilder James S · Eagle, IDBuilt 1958 · S/N 51565 N2265RHodhson Shell S · Wyocena, WIBuilt 1969 · S/N T210-0415 N22669R S Bowen Enterprises LLC · Flowery Branch, GABuilt 2007 · S/N 18281942 N2266SWeekend Air LLC · Incline Village, NVBuilt 1976 · S/N 21061210 N2268SPlatinum Air Services LLC · Morgantown, WVS/N R18201317 N226ACTitle 46 LLC · Hamilton, MTBuilt 1979 · S/N 18267019 N226BBurton Robert B · New York, NYBuilt 1977 · S/N 21061701 N226CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282345 N226JTTerrell Jeffrey L · Clear Lake Shores, TXBuilt 1969 · S/N 18259919 N226LSilver Creek Aviation Services · Fort Worth, TXBuilt 2004 · S/N 20608226 N226SMSarahmaura Aviation Inc · Wayne, NJS/N 18281153 N2271RLowe Vance E · Oakland Park, FLBuilt 1969 · S/N T210-0421 N2272GThompson Todd M · Manito, ILBuilt 1958 · S/N 51572 N2272RBerntsen Kurt · Upland, CABuilt 1969 · S/N T210-0422 N2272XSouthern Seaplane Inc · Belle Chasse, LABuilt 1970 · S/N U206-01556 N2273CCollins John J · Manitowoc, WIBuilt 1953 · S/N 30573 N2274KSantee Cooper Aviation Inc · Saint Matthews, SCBuilt 1978 · S/N 18266454 N2275KSutton Aircraft Salvage LLC · Palmer, AKS/N 51163 N2276GRegistration Pending · Salt Lake City, UTRegistration pendingBuilt 1958 · S/N 51576 N2277YSheffield Richard Lee · Los Alamos, NMBuilt 1972 · S/N 18261225 N2279GParker Robert M · Hurst, TXBuilt 1958 · S/N 51579 N2279RLehmann Albert F II · Simpsonville, SCBuilt 1969 · S/N T210-0429 N2279UChristenberry Paul O · Fayette, ALBuilt 1970 · S/N 18800659 N227BSLec Aviation LLC · Winter Garden, FLBuilt 2007 · S/N 18281943 N227CMMmkb Inc · Wilmington, DEBuilt 1976 · S/N 18264533 N227DKirkland Daniel · Kingman, AZBuilt 1976 · S/N 21061540 N227RJFrost Cavin B · Odessa, TXS/N 18280383 N227SSRiver Front Akn LLC · Anchorage, AKBuilt 1970 · S/N U20601516

Back to AD 84-10-01 R1