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.

N2589GPreisse Gene L Jr · Akron, OHBuilt 1959 · S/N 51889 N2589QMolek Eugene · Warren, OHS/N 18257789 N258MEGolf Delta Charlie LLC · Baton Rouge, LABuilt 2000 · S/N 18280768 N2590KHilltop Aviation Group LLC · Jay, MEBuilt 1978 · S/N 18053006 N2590RMason John A · Scottsdale, AZBuilt 1967 · S/N 18258290 N2591QDeadmond Matthew J · Princeton, CABuilt 1966 · S/N 18257791 N2591TFerguson John W · Edwardsburg, MIBuilt 1975 · S/N U20602594 N2592GLeft Heading LLC · Herriman, UTBuilt 1959 · S/N 51892 N2592XLorraines Blue Sky Aviation LLC · Norman, OKBuilt 1965 · S/N P206-0092 N2593GIntelinair Geospatial LLC · Indianapolis, INBuilt 1958 · S/N 51893 N2593QRigoni Teresa Ann · Orting, WABuilt 1966 · S/N 18257793 N2594QBarer Scott I · Westlake Village, CABuilt 1966 · S/N 18257794 N2595RDierenfeld Michael E · Northwood, IABuilt 1967 · S/N 18258295 N2596GThomas Carlton L · Center, COBuilt 1959 · S/N 51896 N2596QEvening Star Aviation LLC · Corvallis, ORFirst renewal noticeS/N 18257796 N2596RJones Jacob R · Rockford, TNBuilt 1967 · S/N 18258296 N2596XCarter Jason J · Athena, ORBuilt 1965 · S/N P206-0096 N2597KCrossno James · Fulshear, TXBuilt 1978 · S/N 18053010 N2597QCattles Kenneth M Jr · Georgetown, TXBuilt 1966 · S/N 18257797 N2597RWing Frederick K · Milton, MABuilt 1967 · S/N 18258297 N2597XCavaness Gary Frank Jr · Anchorage, AKBuilt 1965 · S/N P206-0097 N2598XGilliland James H · Curwensville, PABuilt 1965 · S/N P2060098 N259CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282349 N259FCState Of Alabama · Montgomery, ALBuilt 2024 · S/N 18283276 N25AFKlik Daniel J · Washington Twp, MIBuilt 1963 · S/N 205-0418 N25AWMukherjee Kaustuv · Simsbury, CTBuilt 1961 · S/N 18253616 N25FCBlumhagen Ryan M · Drake, NDBuilt 1955 · S/N 31520 N25GPAir Data Solutions LLC · Natchitoches, LABuilt 1975 · S/N U20602889 N25HPFlorida Highway Patrol · Tampa, FLBuilt 2006 · S/N 18281842 N25JCAvg LLC · Chico, CABuilt 1959 · S/N 57008 N25ZZ25zz LLC · Abilene, TXS/N 18267202 N2600FZorrilla Peter · Charles Town, WVS/N 18256700 N2600GBad Company Aviation LLC · Peachtree Corners, GABuilt 1959 · S/N 51900 N2600QBivens Jason D · Duncan, OKBuilt 1966 · S/N 18257800 N2600ROrlandella Vito P · Auberry, CABuilt 1967 · S/N 18258300 N2600YCurrin Thomas E · Pendleton, ORBuilt 1962 · S/N 18051100 N2601FFly3h4 LLC · Hillsboro, NDBuilt 1965 · S/N 18256701 N2602GConran Joshua · Belmont, MIBuilt 1959 · S/N 51902 N2602RSiegel Jeffrey P · Snowmass Village, COS/N 18258302 N2603Intentus Aviation LLC · Sunset, TXS/N 32957 N2603FHolloway Graham · Orcutt, CABuilt 1965 · S/N 18256703 N2603KPadilla Management Inc · Burlington, WABuilt 1978 · S/N 18053013 N2603RHopper Jeremy G · Amity, ORS/N 18258303 N2604GBlessing Christopher B · Houston, DEBuilt 1959 · S/N 51904 N2604YLawson Charles A · Arlington, WABuilt 1962 · S/N 18051104 N2605FRose Walter W · Arena, WIBuilt 1965 · S/N 18256705 N2605GInnes Stephen L · Bentonville, ARBuilt 1959 · S/N 51905 N2606QElsayed Von Bayreuth Alaaeldeen Mohamed · Fairfield, CABuilt 1966 · S/N 18257806 N2606XSmith And Cherry Aviation LLC · Knoxville, TNBuilt 1965 · S/N P206-0106 N2607GJensen Rodney · Aptos, CABuilt 1959 · S/N 51907

Back to AD 84-10-01 R1