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.

N66735Ryan Adrian · Anchorage, AKS/N 18052956 N6675MMorrissette Todd · Buxton, MEBuilt 1975 · S/N 18263795 N66764Cuttler Lloyd · Carabaset Vly, MEBuilt 1978 · S/N 18052958 N66765Kalba Shaun B · Pleasant Valley, NYBuilt 1978 · S/N 18052959 N6677BHess Chad · Boise, IDBuilt 1978 · S/N 21062816 N6677RTre Aviation Corp · Wilmington, DES/N 21059654 N6677XMuhlenbrock Guillermo Rene Jr · Las Vegas, NVS/N 21057677 N6678XKinman Kary Wade · Panama City Beach, FLBuilt 1961 · S/N 21057678 N667ARRegistered aircraftBuilt 1977 · S/N 18265379 N667CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 18283236 N667WBMcleod Patrick J · Overgaard, AZBuilt 1967 · S/N 18258563 N6680BBush Douglas B · Santa Rosa Beach, FLBuilt 1978 · S/N 21062818 N6680MMcshane Shannon K · Alamo Heights, TXBuilt 1975 · S/N 18263796 N6682XDuff John W · Alligator, MSBuilt 1960 · S/N 21057682 N6684MMlynarczyk Stanley · Darien, ILBuilt 1975 · S/N 18263798 N6685XTaliaferro John P · Birmingham, ALBuilt 1961 · S/N 21057685 N6686NClarity Aviation LLC · Anchorage, AKBuilt 1978 · S/N 21063146 N6687XReed Ted R · San Angelo, TXBuilt 1961 · S/N 21057687 N6688NLedson Steven Noble · Sonoma, CAS/N 21063148 N6689XBravo Echo Echo LLC · Millersview, TXS/N 21057689 N668DB686 Aviation LLC · Lakewood, COBuilt 1975 · S/N 21061003 N6690MWatson Joseph F · Colorado Springs, COBuilt 1975 · S/N 18263800 N6690XWinston Marine LLC · Bellingham, WABuilt 1961 · S/N 21057690 N6692MEagle Forestry Services Inc · Monticello, ARBuilt 1975 · S/N 18263802 N6694NGear Down LLC · Dalhart, TXBuilt 1978 · S/N 21063150 N6696XTesch Timm A · Spring, TXBuilt 1961 · S/N 21057696 N669CBMckinney Eric · Hamersville, OHBuilt 1976 · S/N 18052725 N669EBBauman Ed · Casstown, OHBuilt 1975 · S/N 21061065 N669PGGood Pilot LLC · Dallas, TXBuilt 1975 · S/N 18263644 N669SRCabot Scott R · Cross Plains, WIBuilt 1970 · S/N 18260492 N66BTTrazer LLC · Parkland, FLBuilt 1964 · S/N 21058437 N66CEM&S Real Estate Management Inc · Granbury, TXS/N 21061391 N66DFClark Samuel D Trustee · Wilson, WYBuilt 1977 · S/N 210-621-41 N66DTTucker Family Agricultural Co LLC · Kiowa, KSS/N 21058931 N66GAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1980 · S/N 20700657 N66HERausch William Donald · Ontario, NYBuilt 2004 · S/N 18281482 N66KJBlagg Robert D III · Santa Fe, NMBuilt 1959 · S/N 51861 N66MJUnited States Air Force (Owner) · Usaf Academy, COS/N 18266399 N66MLBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 21062598 N66RHBoniek Johann C · Nederland, COBuilt 1972 · S/N U20601873 N66RXRegistered aircraftBuilt 1962 · S/N 18253766 N6700TKimmerle David · Blanding, UTBuilt 1963 · S/N 18254862 N6700XAlbert Gregory T · Tucson, AZS/N 21057693 N6703RSteinle Lee M · Jourdanton, TXBuilt 1966 · S/N T210-0103 N6704MBillups Jeff · Eagle, IDBuilt 1975 · S/N 18263806 N6705MRegistration Pending · Stuart, FLRegistration pendingBuilt 1975 · S/N 18263807 N6706MBaker Thaddeus J · Elk, WABuilt 1975 · S/N 18263808 N6706RSzopa Ireneusz W · East Troy, WIBuilt 1965 · S/N T210-0106 N6707RParker David Scott Trustee · Albuquerque, NMBuilt 1965 · S/N T210-0107 N6708MPrecision Aviation Inc · Kimberly, IDBuilt 1975 · S/N 18263809

Back to AD 84-10-01 R1