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.

N9932HFlathead Flight Operations LLC · Kalispell, MTBuilt 1981 · S/N 18268123 N9932NGetz Keith · Murfreesboro, TNBuilt 1975 · S/N 18052587 N9932ZSilver Creek Aviation Services · Fort Worth, TXBuilt 1983 · S/N U20606753 N9933BHenkemeyer Joseph S · Cave Creek, AZBuilt 1957 · S/N 34333 N9933MAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1982 · S/N 20700750 N9933TOrr Kory A · Hay Springs, NEBuilt 1960 · S/N 18253033 N9933ZFreelance Air · Kennesaw, GABuilt 1983 · S/N U20606754 N9934BMasterson Kevin M · Eagle River, AKBuilt 1957 · S/N 34334 N9934EStenger D James Trustee · Sonora, CABuilt 1975 · S/N 18263994 N9934NAtkins Ricky K · Placerville, CABuilt 1975 · S/N 18052589 N9934VRuby Aviation LLC · Oak Creek, COBuilt 1966 · S/N 18051786 N9934XLogue James · Fort Worth, TXBuilt 1975 · S/N 21060916 N9934ZParagon Air Group · Fort Worth, TXBuilt 1983 · S/N U20606755 N9935BCarpenter Willard D · Borrego Springs, CABuilt 1957 · S/N 34335 N9935ERegistration Pending · Belington, WVRegistration pendingBuilt 1985 · S/N 18268474 N9935HKahn Lawrence · Upper Lake, CABuilt 1981 · S/N 18268125 N9935MFreshwater Adventures Inc · Dillingham, AKBuilt 1982 · S/N 20700751 N9935NMeggers Roger D · Baker, MTBuilt 1975 · S/N 18052590 N9935RUsda Aphis Ppq · Edinburg, TXBuilt 1986 · S/N U20606988 N9938NJohnson Scott A · Missoula, MTBuilt 1975 · S/N 18052593 N9938TShope Brandon M · North Pole, AKFirst renewal noticeBuilt 1960 · S/N 18253038 N9938ZSilver Creek Aviation Services · Fort Worth, TXBuilt 1983 · S/N U20606757 N9939NSylvester Sean W · North Pole, AKS/N 18052594 N9939VJackson Walter E · Wasilla, AKBuilt 1966 · S/N 18051791 N9939XGrant Matthew D · Alvord, TXS/N 1850139 N9939ZRiver Front Akn LLC · Anchorage, AKBuilt 1983 · S/N U20606758 N993DWDeadstick Holdings LLC · Laguna Niguel, CABuilt 1963 · S/N 18255149 N993GAUtopia Flyers LLC · Utopia, TXBuilt 1972 · S/N 18261152 N993KTFirst Air Service LLC · Show Low, AZBuilt 1978 · S/N 18266450 N993PPCc Bar Ranch LLC · Texarkana, TXBuilt 1975 · S/N U20602634 N9940ESaint Louis University · Saint Louis, MOBuilt 1975 · S/N 18264000 N9940MSofinme LLC · Missoula, MTS/N U20604590 N9941BBrinkley Christian D · Minneapolis, MNBuilt 1957 · S/N 34341 N9941MAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1982 · S/N 20700748 N9941VMorris Gray S · Chugiak, AKS/N 18051793 N9941ZParagon Air Group · Fort Worth, TXBuilt 1983 · S/N U20606760 N9942MAlaska Aircraft Leasing LLC · Silverdale, WAFirst renewal noticeBuilt 1982 · S/N 20700756 N9943MBristol Bay Air Service Inc · Dillingham, AKBuilt 1982 · S/N 20700757 N9943VNewsom John · Lubbock, TXBuilt 1966 · S/N 18051797 N9943XN63e LLC · Fallon, NVS/N 185-0143 N9943ZState Of Maine Department Of Agriculture · Old Town, MEBuilt 1983 · S/N U20606762 N9944ESw Aviation LLC · Norman, OKBuilt 1975 · S/N 18264004 N9944NJungclaus Karl F · Piedmont, SDBuilt 1975 · S/N 18052599 N9944RCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1986 · S/N U20606993 N9944VHinkes Michael T · Fairbanks, AKBuilt 1966 · S/N 18051798 N9944XChristian Dana J · Bozeman, MTBuilt 1961 · S/N 185-0144 N9944ZChaparral Air Group · Grapevine, TXS/N U20606763 N9945HCbw Holdings LLC · Columbia, TNBuilt 1981 · S/N 18268133 N9946BFuehrer John G II · Ephrata, PABuilt 1957 · S/N 34346 N9946ELorenz Gary W · La Mesa, CABuilt 1975 · S/N 18264006

Back to AD 84-10-01 R1