Skip to content

Registered aircraft · 54,019

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

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 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 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 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 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 N1942XGarrison Weldon · Texarkana, TXBuilt 1979 · S/N P21000296 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 N1945CWassman Dennis B · Moraga, CABuilt 1953 · S/N 26090 N1945FLake Elmo Aero LLC · Lake Elmo, MNBuilt 1979 · S/N 17273035 N1945MOchs Roland P · Brighton, COBuilt 1976 · S/N 18264496 N1945QSmith Thomas E Jr · Chino Hills, CABuilt 1973 · S/N 177RG0345 N1945XStepps Dana · Humboldt, TNBuilt 1965 · S/N 18256045 N19463Aviation Trust Co LLC · Oklahoma City, OKBuilt 1973 · S/N 15074431 N19469Registration Pending · Summerland Key, FLRegistration pendingS/N 15074433 N1946CRegistered aircraftBuilt 1953 · S/N 26091 N1946QMoore Garrie W · Georgetown, TXBuilt 1973 · S/N 177RG0346 N1946VLeading Edge Aviation Inc · Doylestown, PABuilt 1976 · S/N R1722221

Back to AD 87-20-03 R2