Skip to content

Registered aircraft · 20,484

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.

N190ECMiller Dennis G · Galena, ILFirst renewal noticeBuilt 1951 · S/N 7653 N190LSSkinner Lawrence W · Fort Myers, FLBuilt 1950 · S/N 7542 N190P98 Mike LLC · Hayden, IDBuilt 1964 · S/N P206-0012 N190SMelichar Lynn R · Fort Lauderdale, FLS/N 7567 N190VTMarshall Rodney E · Roscoe, ILBuilt 1948 · S/N 7171 N1910MMob Aviation USA LLC · Auburndale, FLBuilt 1975 · S/N 18264475 N1911XSs Aviation LLC · Preston, IDBuilt 1965 · S/N 18256011 N1912XWhite Charles S · Anacortes, WABuilt 1965 · S/N 18256012 N1913XYates Craig J · Indialantic, FLBuilt 1965 · S/N 18256013 N1916Rauser Richard A Trustee · Cottonwood, CABuilt 1974 · S/N 18263299 N1916XCannon Aviation LLC · Morgan, UTBuilt 1965 · S/N 18256016 N1918MWalker Stephen L Trustee · Andover, KSBuilt 1975 · S/N 18264481 N1918XCarlson Brent A · Shelley, IDBuilt 1965 · S/N 18256018 N1920MThompson William F · Fisherville, KYBuilt 1975 · S/N 18264482 N1920XJensen Richard Vaughn · Emmett, IDBuilt 1965 · S/N 18256020 N1921MRed Shirt Resources LLC · Weatherford, TXBuilt 1975 · S/N 18264483 N1922TBiscoe Donald M · Cottage Grove, MNBuilt 1969 · S/N 21059220 N1922XHerman Joseph T · Lovell, WYBuilt 1965 · S/N 18256022 N1924XTahiac Aviation LLC · Berryton, KSS/N 18256024 N1925XBtak LLC · New Baden, ILBuilt 1965 · S/N 18256025 N1926UBarrett Michael D · Anchorage, AKBuilt 1973 · S/N U20602287 N1926XWilkerson Kelvin E Jr · Kannapolis, NCBuilt 1965 · S/N 18256026 N1927TZ And N 1927t LLC · Wapella, ILBuilt 1977 · S/N 182-65857 N192CMFriehe Berend · Moses Lake, WABuilt 1981 · S/N U20606160 N192TGSaz Dynamics LLC · Daly City, CABuilt 2005 · S/N 18281524 N192YSanders Leonard S III · Electric City, WABuilt 2000 · S/N 18280912 N1930XDuff James J · Pueblo, COBuilt 1965 · S/N 18256030 N1931XRuffner Ryon Garrett · Argyle, TXBuilt 1965 · S/N 18256031 N1933MShepherd Matthew R · Bloomington, INBuilt 1976 · S/N 18264487 N1933XHall Michael D · Athens, ALBuilt 1965 · S/N 18256033 N1934MKornetzke Jeffrey A · Lake Mills, WIBuilt 1976 · S/N 18264488 N1934XMarshall Michael R · Collierville, TNBuilt 1965 · S/N 18256034 N1936MScott George M · Reno, NVS/N 18264489 N1936XNelson William T · Benton, KYBuilt 1965 · S/N 18256036 N1937MPoultry Not Beef LLC · Chancellor, ALBuilt 1976 · S/N 18264490 N1937XOrtiz Marquez Ricardo A · Melbourne, FLBuilt 1965 · S/N 18256037 N1939X1939xray LLC · Chester, SCBuilt 1965 · S/N 18256039 N193GSWeaver Family Farms LLC · Corpus Christi, TXBuilt 1970 · S/N 18260442 N193LBRiverway Capital LLC · Houston, TXBuilt 1976 · S/N 20700360 N193PNc Wildlife Resources Commission Enforcement Div · Raleigh, NCBuilt 2008 · S/N 20608307 N193RChase David C · Anchorage, AKBuilt 1969 · S/N 182-59879 N193TATuck Aerial Surveys Inc · Big Stone Gap, VABuilt 1980 · S/N U20605946 N193TTBgiii Air LLC · Tampa, FLBuilt 1976 · S/N 21061601 N1941BSan LLC · Knoxville, TNBuilt 2021 · S/N 18283158 N1941MEf Air Holdings LLC · Midkiff, TXBuilt 1976 · S/N 18264493 N1942MRegistration Pending · Linn, TXRegistration pendingBuilt 1976 · S/N 18264494 N1943MBenbrook Robert A · Blairstown, NJBuilt 1977 · S/N 21061968 N1945MOchs Roland P · Brighton, COBuilt 1976 · S/N 18264496 N1945XStepps Dana · Humboldt, TNBuilt 1965 · S/N 18256045 N1948XGreenwood Auto LLC · Itta Bena, MSBuilt 1965 · S/N 18256048

Back to AD 84-10-01 R1