OpenAirDocs.org
AD 2008-09-18

Registered aircraft · 1,741

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

N1023DGregg John I Jr · Glendale, AZS/N 10520N108DShettel Jay E · Boiling Springs, PAS/N MT-1N10JLSmith Loren D · Great Falls, MTBuilt 1946 · S/N 6681N111THMartin Jesse A · Gainesville, FLBuilt 1946 · S/N 10044N1182KUllrich Sandy J · Haskell, OKS/N 8309N121BXEnglish Dexter · Syracuse, KSS/N 8960N128ZKammer Frank B · Ringgold, GAS/N 7149N13HSGregg Brian L · Guthrie, OKS/N F-039N144ELubeck Thomas L · Anchorage, AKBuilt 1974 · S/N F-013N1510TRegistered aircraftAssigned, pending cancellationS/N 2868N17226Eaa Chapter 1077 · New Philadelphia, OHBuilt 1939 · S/N 1892N17390Taylor Douglas B · New Middletown, OHBuilt 1936 · S/N 25N175JBWhitcher Garrick L · Woodburn, ORS/N 1607N18305Morozowsky Anthony M · Zanesville, OHS/N 36N18312Black Wallace D · Tuttle, OKBuilt 1937 · S/N 45N18336Davis Trenten E · Brodhead, WIBuilt 1937 · S/N 69N18339Strine Russell A · Reading, PABuilt 1937 · S/N 72N18340Hannam Michael J · Runnells, IABuilt 1937 · S/N 73N18345Baker Lowell T · Effingham, ILBuilt 1937 · S/N 78N18365Mann Thomas A · Ford, WABuilt 1937 · S/N 97N18644Petrie Robert J · Eagleville, TNBuilt 1937 · S/N 251N18ECJenkins Norman G · North Pole, AKBuilt 1977 · S/N F-083N19008Martin Allan E · Suquamish, WABuilt 1937 · S/N 114N19028Cannard Marius A · Shullsburg, WIS/N 134N19062Coffman Donald E · Heber, AZBuilt 1937 · S/N 168N1935Cavanaugh Darrel N · Wasilla, AKBuilt 1940 · S/N 1935N1938BKing Richard S · San Antonio, TXBuilt 1938 · S/N 1101N1939TDickhudt Gene R · Mcpherson, KSBuilt 1940 · S/N 1870N1941XNezgoda Daniel A Jr · Las Vegas, NVS/N 2558N19461Bouchard Jason A · Carmel Valley, CAS/N 9820N194KJCollins Richard F · Lake Wales, FLBuilt 1948 · S/N 12010N1951JDelaney John D · Mineral Point, WIBuilt 1946 · S/N 9902N19608Petro Jerry R · Williamsburg, VABuilt 1937 · S/N 214N19612Braness Jim G · Richmond, MNS/N 219N19615Pearlman Aircraft Co · Orlando, FLBuilt 1937 · S/N 222N19649Lindquist Lucy M · Hampshire, ILBuilt 1937 · S/N 256N19653Ranger Airfield Foundation · Ranger, TXBuilt 1937 · S/N 260N19660Meyer Jeremy · Conway Springs, KSBuilt 1937 · S/N 267N19693Byrd David J · Greensboro, NCBuilt 1937 · S/N 300N197HKaspar Russell B · Frankfort, INBuilt 1941 · S/N 2915N19826Poorman Benjamin T · Wauseon, OHBuilt 1937 · S/N 331N19829Pope Andrew W · New Boston, TXS/N 334N19832Helgerson David · Ottumwa, IAS/N 337N19844Lindquist Lucy M · Hampshire, ILBuilt 1937 · S/N 349N1985WKaplanov Kervin Rebecca A · Grosse Pointe, MIBuilt 1937 · S/N 360N19JLPodeweltz Dana A · Merrill, WIBuilt 1946 · S/N 6719N19TEBolton Adam W · Anchorage, AKS/N F-104N20004Kania Chester J Jr · Alton, NHBuilt 1978 · S/N F-129N2000UHanscom Rodney L · Holden, MEBuilt 1978 · S/N F-124N2000VHobson George A · Fairbanks, AKBuilt 1978 · S/N F-125
Back to AD 2008-09-18