Skip to content

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.

N6453ALight John William · Anchorage, AKBuilt 1956 · S/N 33253 N6453HNorth Shore Aero Club Inc · Beverly, MAS/N 18267890 N6453NUgly Johns Aircraft LLC · Afton, OKBuilt 1978 · S/N 21063028 N6455CPruett Steven H · Midland, TXBuilt 1980 · S/N 21063893 N6455FSan Copertino LLC · Rome, GABuilt 1975 · S/N 18264196 N6455XGreat Basin Aviation LLC · Eagle River, AKBuilt 1961 · S/N 18050955 N6456UN909dw LLC · Helena, MTBuilt 1985 · S/N 21064954 N6456XBurgess Mark W · Greene, MEBuilt 1961 · S/N 18050956 N6457BJcb Holdings LLC · Helena, MTBuilt 1978 · S/N 21062768 N6458AStebbins Robert B · Georgetown, TXBuilt 1956 · S/N 33258 N6459CBallair LLC · Dalhart, TXBuilt 1980 · S/N 21063895 N645FCFlorida Dept Of Agriculure & Consumer Services · Tallahassee, FLBuilt 2021 · S/N 18283152 N6460HWhitetail LLC · Anchorage, AKBuilt 1979 · S/N 20700530 N6461XKrause Aviation LLC · Geneva, ILBuilt 1960 · S/N 18050961 N6461ZJav Air Services LLC · Anchorage, AKBuilt 1981 · S/N U20606282 N6463ABiocca Richard · Tucson, AZBuilt 1956 · S/N 33263 N6465ABertonazzi Kevin M · Vineland, NJFirst renewal noticeBuilt 1956 · S/N 33265 N6465THurricane Corp · New York, NYS/N R18202033 N6466ARobinson Jerry L · Mc Call, IDBuilt 1956 · S/N 33266 N6466NHagan Joseph · Steward, ILBuilt 1978 · S/N 21063040 N6469NKestrel Aviation LLC · La Center, WABuilt 1978 · S/N 21063043 N646CDRegistered aircraftBuilt 1979 · S/N 21063402 N646FCFlorida Dept Of Agriculture And Consumer Services · Tallahassee, FLBuilt 2023 · S/N 18283246 N6470HJb Aircraft LLC · Anchorage, AKBuilt 1979 · S/N 20700534 N6470YSkyhigh Enterprises LLC · Holland, MIBuilt 1981 · S/N 21064396 N6471AGwinn Anthony N · Melbourne, FLBuilt 1956 · S/N 33271 N6471XClimie Kenneth A · Plano, TXS/N 18050971 N6472GMiralou Aero LLC · Pittsburgh, PABuilt 1974 · S/N 18263313 N6473ASkydive Snohomish Inc · Snohomish, WABuilt 1956 · S/N 33273 N6474XMay Jeremy A · Norco, CABuilt 1961 · S/N 18050974 N6475XTwin Oaks Aircraft Maintenance LLC · Hillsboro, ORBuilt 1961 · S/N 18050975 N6476TAngel Air Ltd · Smithvile, OHBuilt 1986 · S/N R18202035 N6477HTurbines Ltd · West Point, NES/N 20700537 N6477TPhillips Christopher R · Peoria, AZBuilt 1986 · S/N R18202036 N6479FFurick Robert P · Woodinville, WABuilt 1975 · S/N 18264200 N6479NSouth Aero LLC · Albuquerque, NMBuilt 1978 · S/N 21063053 N6479XSutton Aircraft Salvage LLC · Palmer, AKBuilt 1961 · S/N 18050979 N6479YGv Air Inc · Medford, ORBuilt 1981 · S/N 21064399 N647SBHyde Matthew L · Santa Cruz, CABuilt 1982 · S/N 21064743 N6482AMoreman Wiley E · Willcox, AZBuilt 1956 · S/N 33282 N6482YSky West Aviation Inc Trustee · Albuquerque, NMS/N 21064400 N6483AKdrcjt Aviation LLC · Orange, MAS/N 33283 N6484AState Of Illinois · Springfield, ILBuilt 1979 · S/N 21063535 N6484XMeadows Robert H · Charleston, TNFirst renewal noticeBuilt 1961 · S/N 18050984 N6486AErickson Jon W · Union Grove, WIBuilt 1956 · S/N 33286 N6487ALucci Giancinto A · Nashville, MIS/N 33287 N6489HMoon Flight Aviation LLC · Barto, PABuilt 1981 · S/N 18267891 N6489XBargainnier Devin T · Carson City, NVBuilt 1961 · S/N 18050989 N648BDHansen Robert C · Delavan, WIBuilt 1978 · S/N 18266461 N648DWDewhipet LLC · Sibley, LABuilt 1966 · S/N P206-0252

Back to AD 84-10-01 R1