Skip to content

Registered aircraft · 56,578

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N1937FA2 Flight Leasing LLC · Castro Valley, CABuilt 1979 · S/N 17273027 N1937MPoultry Not Beef LLC · Chancellor, ALBuilt 1976 · S/N 18264490 N1937XOrtiz Marquez Ricardo A · Melbourne, FLBuilt 1965 · S/N 18256037 N19380Fannin William A II · Lexington, KYS/N 15074378 N19384Armstrong Thomas J · Ann Arbor, MIBuilt 1973 · S/N 15074381 N19387Debo Group Inc · Uniontown, OHBuilt 1976 · S/N 17702567 N19388Kittner Robert T · Ellenville, NYBuilt 1973 · S/N 15074383 N19389Clenow Mark · Brighton, MABuilt 1973 · S/N 15074384 N1938ZSuffern Glenn · Shady Shores, TXS/N 15059738 N1939QGustafson Keith W · Waleska, GABuilt 1973 · S/N 177RG0339 N1939SFallon Timothy · Center Barnstead, NHBuilt 2005 · S/N 172S9974 N1939X1939xray LLC · Chester, SCBuilt 1965 · S/N 18256039 N1939ZBrooks James R · Oak Grove, MOBuilt 1962 · S/N 15059739 N193GSWeaver Family Farms LLC · Corpus Christi, TXBuilt 1970 · S/N 18260442 N193JSRyan Moore LLC · Fayetteville, NCBuilt 1975 · S/N 17265118 N193LBRiverway Capital LLC · Houston, TXBuilt 1976 · S/N 20700360 N193MEHorizon Flight Center LLC · Chesapeake, VABuilt 2000 · S/N 172S8458 N193PNc Wildlife Resources Commission Enforcement Div · Raleigh, NCBuilt 2008 · S/N 20608307 N193RChase David C · Anchorage, AKBuilt 1969 · S/N 182-59879 N193RJSale Reported · Henderson, NVSale reportedBuilt 1980 · S/N R1723315 N193SPIndiana State Police · Greenwood, INS/N 172-76346 N193TATuck Aerial Surveys Inc · Big Stone Gap, VABuilt 1980 · S/N U20605946 N193THWingsleasing LLC · Wichita, KSBuilt 2015 · S/N 172S11551 N193TTBgiii Air LLC · Tampa, FLBuilt 1976 · S/N 21061601 N19400Bailis David P · Bethlehem, PAS/N 15074395 N19404Borden Kim L · Fair Haven, NYBuilt 1973 · S/N 15074399 N19405Blenden Stephen R · Orlando, FLBuilt 1977 · S/N 17702569 N19406Clark Caroline Ray · Anderson, SCS/N 15074401 N19409Owen James A · Jud, NDBuilt 1973 · S/N 15074404 N1940FAmerican Asset Leasing LLC · Livermore, CAS/N 17273030 N19410Sather Evan A · Hayward, CABuilt 1973 · S/N 15074405 N19413Ahlgren Jon E · Juneau, AKBuilt 1973 · S/N 15074406 N19414Bailey Brian D · Bethesda, MDFirst renewal noticeBuilt 1973 · S/N 15074407 N19419Dean Aviation LLC · Merritt Island, FLBuilt 1976 · S/N 17702570 N1941BSan LLC · Knoxville, TNBuilt 2021 · S/N 18283158 N1941MEf Air Holdings LLC · Midkiff, TXBuilt 1976 · S/N 18264493 N19422Bellefontaine Georges E · Shady Shores, TXBuilt 1973 · S/N 15074413 N1942CPfister Robert T · Stuart, FLBuilt 1953 · S/N 26087 N1942MRegistration Pending · Linn, TXRegistration pendingBuilt 1976 · S/N 18264494 N19439Technical Education Services Inc · Virginia Beach, VABuilt 1973 · S/N 15074419 N1943CLacey Miles H · Valley Springs, SDBuilt 1953 · S/N 26088 N1943MBenbrook Robert A · Blairstown, NJBuilt 1977 · S/N 21061968 N1943QLeonard Joseph · Bohemia, NYBuilt 1973 · S/N 177RG0343 N1943ZBeauford Bryan Tyler · Anderson, MOBuilt 1962 · S/N 15059743 N19445Scott Beau · Ashville, OHBuilt 1976 · S/N 17702572 N1944C1944 Charli LLC · Bristol, CTBuilt 1953 · S/N 26089 N1944QHenry Peter S · Olympic Valley, CABuilt 1973 · S/N 177RG0344 N1944ZHauser Linda L · Ulysses, KSBuilt 1962 · S/N 15059744 N19451Allison Jeremy L · Chandler, AZBuilt 1973 · S/N 15074427 N19453Top Flight LLC · Wilmington, DES/N 15074429

Back to AD 79-10-14 R1