Skip to content

Registered aircraft · 20,485

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.

N171SPState Of Iowa - Iowa State Patrol · Des Moines, IABuilt 2007 · S/N 18281977 N171STDkg Motorized Conveyances Inc · Beaverton, ORBuilt 2000 · S/N 18280703 N171TMG&L Aviation Services LLC · Las Vegas, NVBuilt 1980 · S/N 21063894 N171UNancy Unicorn LLC · Seattle, WABuilt 1982 · S/N 18268147 N171WBYeager Hal J · Winterset, IABuilt 1975 · S/N 18264036 N1720XKregel Brian D · Garnavillo, IABuilt 1975 · S/N 21060742 N1721CLemons Air LLC · Boulder, COS/N 30421 N1721RStecher Allan · Thornton, COBuilt 1978 · S/N R18200534 N1722CA G Sholton Co · Wasilla, AKBuilt 1953 · S/N 30422 N1723BBoyko George · Tarpon Springs, FLBuilt 1979 · S/N 206-05190 N1723CDi Gangi Stephen S · Spokane, WABuilt 1953 · S/N 30423 N1724CLentz Walter E · Duncan, OKBuilt 1953 · S/N 30424 N1724LAzul Assets LLC · Santa Fe, NMBuilt 2007 · S/N 18282018 N1724RBlue Eagle Aviation LLC · Azle, TXS/N R18200536 N1724THanna David B · Tonasket, WABuilt 1964 · S/N 21058360 N1725CC Wolf Inc · Ord, NEBuilt 1953 · S/N 30425 N1725LMeyer Frank · Williamsburg, VABuilt 2007 · S/N 18282019 N1725MAirbach LLC · Irvington, KYBuilt 1975 · S/N 18264418 N1727CCarr Richard A · Boulder City, NVBuilt 1954 · S/N 30427 N17281Martin Air LLC · Fort Wayne, INBuilt 1960 · S/N 50774 N1728CMasek Lawrence J · Cuyahoga Falls, OHBuilt 1953 · S/N 30428 N1728MAnderson Michael · Missoula, MTBuilt 1975 · S/N 18264419 N1729CN8969v LLC · Anchorage, AKBuilt 1953 · S/N 30429 N1729FAllmann Mark F Trustee · Kent, WABuilt 1954 · S/N 30619 N172AAStuart S Macpherson Dds Inc · Cardiff By The Sea, CABuilt 1954 · S/N 30757 N1732ARegistration Pending · Farragut, TNRegistration pendingBuilt 2007 · S/N 18282032 N1732LJohnson Ralph R Jr · Roanoke Rapids, NCBuilt 2007 · S/N 18282033 N1732RHeath William D Jr · Bremen, GABuilt 1978 · S/N R18200539 N1733RNorthstar Holdings LLC · Anchorage, AKBuilt 1973 · S/N U20602068 N1734UWing Nutz LLC · Pasadena, CABuilt 1982 · S/N 21064735 N1734XRight Wing Left Wing Flyers LLC · Cleveland, GABuilt 1975 · S/N 21060755 N1735MG & M Aircraft Inc · Wheat Ridge, COBuilt 1975 · S/N 18264421 N1736CThompson Frank L · Weiser, IDBuilt 1953 · S/N 30436 N1737CBristol Brian P · Webster, MNBuilt 1953 · S/N 30437 N1737LZdad Aviation LLC · Little Rock, ARBuilt 2007 · S/N 18282038 N1737MClinton Aviation Corp · Clinton, ARBuilt 1975 · S/N 18264423 N1737RMorales Richard · Palm Springs, CABuilt 1978 · S/N R18200541 N1737STms Aviation Inc · Wilmington, DEBuilt 2000 · S/N 18280763 N1738CScc Aviation LLC · Caldwell, TXBuilt 2007 · S/N 18282040 N1739COpp Daniel · Anchorage, AKBuilt 1953 · S/N 30439 N173CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 18283269 N173MCCiochetti Michael J Jr · Clayton, GABuilt 1968 · S/N 21058960 N173VRDauria William · Anna, TXBuilt 1971 · S/N 18260781 N1741CWitt William A · Ennis, MTBuilt 1953 · S/N 30441 N1742XR&C Aviation Partners LLC · Tucson, AZBuilt 1975 · S/N 21060763 N1744XDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 21060765 N1746CGreen Gary Dale · Mccarthy, AKBuilt 1953 · S/N 30446 N1746RSky West Aviation Inc Trustee · Albuquerque, NMS/N R18200543 N1747BDgpiper · Sheridan, WYBuilt 1980 · S/N 20700666 N1747CConatser Patrick M · Homeland, CABuilt 1953 · S/N 30447

Back to AD 84-10-01 R1