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.

N2442QCoastal Business Systems Inc · Eureka, CABuilt 2001 · S/N 18280938 N2443HSilver Star Jet LLC · Delafield, WIBuilt 2000 · S/N 18280702 N2443QHolcomb Aviation LLC · Middleton, IDS/N 18257643 N2443RYoung David E · Wasilla, AKBuilt 1964 · S/N 18255543 N24440Stikes Aviation LLC · Griffin, GABuilt 2001 · S/N 18280956 N2444GDurbin Brian · Lone Tree, COBuilt 1959 · S/N 51744 N2444QBristow Christopher W · Fairfield, TXBuilt 1966 · S/N 18257644 N2444RClancy Michael · Rifle, COBuilt 1964 · S/N 18255544 N2444XRocha Frank N · Knights Ferry, CAFirst renewal noticeBuilt 1965 · S/N 18256344 N2445JBuzzard Aviation Inc · Freer, TXBuilt 2000 · S/N 20608095 N2445RVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 18281720 N2445VN2445v Cessna Inc Trustee · Wilmington, DEBuilt 2000 · S/N 18280699 N2445XBald Eagle Aviation LLC · West Chester, PABuilt 1965 · S/N 18256345 N2446ASkybound Aviation LLC · Bixby, OKBuilt 2000 · S/N 18280695 N2446CGolike Timothy R · Anchorage, AKBuilt 1954 · S/N 30746 N2446GAcute Holdings LLC · Jenks, OKBuilt 1959 · S/N 51746 N2446REdgon Inc · Orlando, FLS/N 18280697 N2446SFerreby Thomas E · Stroudsburg, PABuilt 2000 · S/N 18280698 N2446XWashington State Patrol · Olympia, WABuilt 2000 · S/N 20608097 N24470Bauer Richard E · Livermore, CABuilt 2000 · S/N 18280823 N2447CLevya Kevin S · Wilbur, WAS/N 30747 N2447GTroyer Thomas · Chickamauga, GABuilt 1959 · S/N 51747 N2447QEaton James B · Green Bank, NJBuilt 1966 · S/N 18257647 N24480Moscair LLC · Nashville, TNBuilt 2001 · S/N 18280932 N2448FFlynn Charles P · Anchorage, AKBuilt 1965 · S/N 18051648 N2448QEuroaviation Inc Trustee · KematenS/N 18257648 N2448XBlough Robert M · Hoonah, AKBuilt 1965 · S/N 18256348 N2449AWestbank Fishing LLC · Kiln, MSBuilt 1999 · S/N 18280632 N2449CAirmart Aircraft Holdings Inc · Oak Ridge, NCBuilt 1999 · S/N 18280633 N2449FBoccuti Salvatore A · Ambler, PABuilt 1966 · S/N 18051650 N2449GDimzoff Justin W · Hines, ORFirst renewal noticeBuilt 1959 · S/N 51749 N2449QAcme Aircraft Co III LLC · Arvada, COBuilt 1966 · S/N 18257649 N2449TElevation Club Air LLC · Hunting Valley, OHBuilt 2005 · S/N 18281727 N244DBAnsari Ramin · West Lafayette, INBuilt 1976 · S/N 18265043 N244HEDubin David A · Tucson, AZS/N 21058990 N244RPMitchell N Andrew · Bridgeport, CTBuilt 1973 · S/N 182-62311 N244SPToth Douglas F · Scottsdale, AZBuilt 1963 · S/N 205-0379 N2450GMathieson Erik L · Kapowsin, WABuilt 1959 · S/N 51750 N2450QSherry Mark A · Walla Walla, WABuilt 1966 · S/N 18257650 N2450XBackcountry LLC · Ennis, MTBuilt 1965 · S/N 18256350 N2451CWilliams Marc Alomzo · Fallon, NVBuilt 1954 · S/N 30751 N2451FMontana Rose 185 LLC · Cornwall, VTBuilt 1965 · S/N 18051652 N2451GHerring Gary A · Elverson, PAS/N 51751 N2451HBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 18280950 N2451QAviation Mission 3:16 LLC · White Lake, MIBuilt 1966 · S/N 18257651 N2451UVandyke John D Trustee · Hudsonville, MIBuilt 2001 · S/N 18280943 N2451ZMasciola Michael J · Dunn Loring, VABuilt 2001 · S/N 18280949 N2452FPesicka Theodore J · Hermiston, ORBuilt 1966 · S/N 18051654 N2452QCallihan Richard L · Manning, SCBuilt 1966 · S/N 18257652 N2452RKnutson Wayne R · Thompson, NDS/N 182-55552

Back to AD 84-10-01 R1