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.

N9478T4cl Inc · Wilmington, DEBuilt 1960 · S/N 57278 N9479GCox Ramona T · Manhattan Beach, CABuilt 1971 · S/N U20601679 N947CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281974 N947ETGranite State Aerial Topography LLC · Wolfeboro, NHBuilt 1973 · S/N U20602271 N94800Trick Aviation LLC · Kalispell, MTBuilt 1978 · S/N 18266512 N94810Kaski Brian · Battle Ground, WABuilt 1978 · S/N 18266515 N94812James Hamilton Construction Co · Silver City, NMS/N 18266517 N9481CWhitby Christopher W · Prescott, AZBuilt 1955 · S/N 31879 N9481X2310 Woodcrest LLC · Freeland, PABuilt 1961 · S/N 21057781 N94823Black Hills Information Security Inc · Bozeman, MTBuilt 2013 · S/N 18282363 N94825Vaughan Aviation LLC · Leesburg, VABuilt 2013 · S/N 18282324 N9482MWestwind Aviation Inc · Phoenix, AZBuilt 1981 · S/N 20700698 N94837Leyser Joshua F C · Tega Cay, SCS/N 18266521 N9483HDelbrocco Christopher A · Waitsfield, VTBuilt 1981 · S/N 18267955 N9483YSioux Falls Technology LLC · Sioux Falls, SDBuilt 1981 · S/N 21064520 N9484CKnowles Jayson C · Winter Harbor, MEBuilt 1955 · S/N 31882 N9484XD&J Air Adventures Inc · Koloa, HIBuilt 1985 · S/N 18268537 N94853Middle Georgia Aviation Services LLC · Warner Robins, GABuilt 1978 · S/N 18266523 N94854Sutliff John K · Walla Walla, WAS/N 18266524 N9485XBruckman Monty D · Edgewood, NMBuilt 1961 · S/N 21057785 N9486GAndrew Odean T · Willow, AKBuilt 1971 · S/N U20601686 N9486HStegehuis Richard L · Helenville, WIBuilt 1981 · S/N 18267957 N9486XSchilling Aviation Services LLC · Salina, KSBuilt 1961 · S/N 21057786 N94872Weber Brian T · Hastings, MNBuilt 1978 · S/N 18266527 N9487RBoyer Air Lc · West Des Moines, IABuilt 1978 · S/N R18200710 N9488MAero Guard Aviation Insurance LLC · Lincoln, NEBuilt 1976 · S/N 18264771 N94897Baca Raymundo · El Paso, TXBuilt 1978 · S/N 18266530 N9489TRegistered aircraftRegistration pendingBuilt 1960 · S/N 57289 N9489XRegistration Pending · Libby, MTRegistration pendingS/N 21057789 N9489ZMoody Bible Institute Of Chicago · Spokane, WABuilt 1981 · S/N U20606525 N948CPCivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282115 N94908Robert E Carroll Logging Inc · Ebony, VAS/N 18266531 N9490CBell Scott Walker · Greeley, COBuilt 1955 · S/N 31888 N9490XStrode Farms Inc · Owensboro, KYBuilt 1985 · S/N 18268538 N9490YKearins John M · North Hampton, NHBuilt 1969 · S/N 20700110 N94916Milne Dave · Snohomish, WABuilt 1978 · S/N 18266534 N94918Urfer Kenneth M · Sparks, NVBuilt 1978 · S/N 18266535 N9491CTerhune Keith B · Crosby, TXS/N 31889 N94937Kidder Robert S · Burlington, KYBuilt 1978 · S/N 18266539 N94938Kalaiselvan Arunram · Richland, GAS/N 18266540 N9493CBlue Thunder LLC · Ketchum, IDBuilt 1955 · S/N 31891 N9493TCorwin Bert C · Rapid City, SDBuilt 1960 · S/N 57293 N9493XAce Pools · Choctaw, OKS/N 18268539 N9493ZCcf Ventures Inc · Bangor, MEBuilt 1981 · S/N U20606527 N94940Shurley Billy R · Cabot, ARBuilt 1978 · S/N 18266541 N94944Jav Air Services LLC · Anchorage, AKBuilt 1978 · S/N 18266542 N94946Van Duzer John P · Alpine, CABuilt 1978 · S/N 18266544 N9494LRegistration Pending · French Village, MORegistration pendingS/N 57294 N9495XLafranchi Logan Michael · Calistoga, CABuilt 1961 · S/N 21057795 N9496CGust Dale A · Boise, IDBuilt 1955 · S/N 31894

Back to AD 84-10-01 R1