Skip to content

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.

N254SWalker Curtis · Lake Havasu, AZS/N 21061198 N254TSGiesbrecht Nolan R · Burns, ORBuilt 1974 · S/N U20602381 N2550RSmalldridge Jonathan D · Arcadia, CABuilt 1967 · S/N 18258250 N2550SGrewal Amritpal S · Stockton, CAS/N 21061326 N2551GDaum Cole C · Woodstock, GABuilt 1959 · S/N 51851 N2551RHendrix Casey W · Ennis, TXBuilt 1967 · S/N 18258251 N2551XMcgrath Paul · Potsdam, NYBuilt 1965 · S/N P206-0051 N2552KRicci Harry A · Kokhanok, AKBuilt 1978 · S/N 18052983 N2552RHooper Jerald Ray · Parker, AZBuilt 1967 · S/N 18258252 N2552XN2552x LLC · Boulder, COBuilt 1964 · S/N P206-0052 N2553GRegistered aircraftS/N 51853 N2553QSanders William R Jr · Lafayette, COBuilt 1966 · S/N 18257753 N2553RDepore Joseph E · Charleston, SCBuilt 1967 · S/N 18258253 N2554KBelleair Aviation LLC · Clearwater, FLS/N 18052985 N2554RBartlett Richard H · Sussex, NJBuilt 1967 · S/N 18258254 N2554XWallin Justin · Henderson, NVBuilt 1964 · S/N P206-0054 N2554ZClement L Ross · Anchorage, AKBuilt 1963 · S/N 185-0554 N2556KCarlson Steven J · Fairbanks, AKS/N 18052986 N2556XHusnik Brad M · Forest Lake, MNFirst renewal noticeBuilt 1964 · S/N P206-0056 N2557RWhite Willis W · Boise, IDBuilt 1967 · S/N 18258257 N2557SAgri-Flight LLC · Waterford, MIS/N R18201349 N2557XRegistration Pending · Troy, IDRegistration pendingBuilt 1964 · S/N P206-0057 N2558GScolari Shawn Fenton · Meeteetse, WYS/N 51858 N2558RKahn Steven P · Boise, IDBuilt 1967 · S/N 18258258 N2559JStuder Alfred C · Shelby, MIBuilt 1979 · S/N T18803482T N2559QJordan Valley Aviation LLC · Jordan Valley, ORBuilt 1966 · S/N 18257759 N2559XElement Building Solutions Inc · Murphys, CABuilt 1965 · S/N P2060059 N255ATThompson Aaron R · Louisville, KYS/N 18280060 N255CETextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2024 · S/N 18283255 N255FLCoutts Dylan A · Windsor, MEBuilt 1998 · S/N 18280241 N255MEFalbo Michael Wayne · Sellersburg, INBuilt 2000 · S/N 18280765 N255WFKlapmeier Alan L · Iron River, WIBuilt 1981 · S/N R18201655 N2560GJackson Air LLC · Temecula, CABuilt 1959 · S/N 51860 N2560XCd Hillcroft Aviation LLC · Superior, COBuilt 1965 · S/N P206-0060 N2561QMariposa Aviation Inc · East Wenatchee, WABuilt 1966 · S/N 18257761 N2561RHeber Valley Flying Club · Park City, UTBuilt 1967 · S/N 18258261 N2561XN343ga Leasing LLC · Anchorage, AKBuilt 1965 · S/N P206-0061 N2562QStiles Thomas W · Pocahontas, ILBuilt 1966 · S/N 18257762 N2562RKehler Grain & Livestock · Saint Xavier, MTBuilt 1967 · S/N 18258262 N2563SClements Kenneth Brian · Las Vegas, NVBuilt 1976 · S/N 21061330 N2563ZWien Richard A · Fairbanks, AKBuilt 1963 · S/N 185-0563 N2564GGarrison Jeffrey R · Clemson, SCBuilt 1959 · S/N 51864 N2564RBusse William J · Twin Lakes, WIBuilt 1967 · S/N 18258264 N2564ZDownwind Aviation LLC · Kodiak, AKBuilt 1963 · S/N 185-0564 N2565GMoore Timothy L · Wendell, IDBuilt 1959 · S/N 51865 N2565RSanders David D · Alvin, TXBuilt 1967 · S/N 18258265 N2566RRastetter Harold · Douglaston, NYBuilt 1967 · S/N 18258266 N2567GSunrise Exploration Inc · Northport, WABuilt 1959 · S/N 51867 N2567KBryant Kenneth D · Black Diamond, WABuilt 1978 · S/N 18052990 N2567RGone Flying LLC · Loveland, OHBuilt 1967 · S/N 18258267

Back to AD 84-10-01 R1