OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  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.

N612TGadler Timothy L · Lake Oswego, ORBuilt 1958 · S/N D-5438N6130VKwalek Robert E · Shelton, CTBuilt 1965 · S/N D-7797N6132XKeller Keith E · Harvard, NEBuilt 1982 · S/N E-1950N6133NSiesta Key LLC · Wilmington, DES/N M-1216N6134NChris Bellinger Dvm LLC · Newalla, OKS/N MA-345N6134ZCji LLC · Winston Salem, NCBuilt 1981 · S/N E-1952N6135CMiller William J · Ferriday, LABuilt 1981 · S/N E-1954N6135VSteinle Michael · Lake Village, INBuilt 1965 · S/N D-7787N6136VCcf Ventures Inc · Bangor, MEBuilt 1965 · S/N D-7788N6137VCarpmail Michael · Yakima, WABuilt 1965 · S/N D-7789N613AWMoreno Carlos · Ocala, FLBuilt 1966 · S/N M-939N613BPhotakis Gary B · Kirkland, WABuilt 1957 · S/N D-5415N613DJacobsen Christopher C · Sandy, UTS/N D-2870N613MWChip Aviation LLC · Sarasota, FLBuilt 1976 · S/N E-805N613TPrice Melvyn J · Lancaster, SCBuilt 1958 · S/N D-5430N6140NMurray Edward K · Fallbrook, CABuilt 1981 · S/N TC-2428N6141VWright Lawrence D · West Chester, PABuilt 1965 · S/N TD-614N6143NTorikawa Domingojason K · Ewa Beach, HIBuilt 1969 · S/N MB-414N6144CLacour Chad · Baton Rouge, LAS/N P-585N6144NDunn Rick · Benton, ARS/N MB-415N6145JGoodman Aircraft Inc · Wilmington, DEBuilt 1982 · S/N TC-2429N6146MBluewater Na LLC · San Diego, CABuilt 1981 · S/N E-1959N6147VBerry David A · Santa Cruz, CABuilt 1961 · S/N D-7791N61487Vspeed LLC · Saint Paul, MNBuilt 1983 · S/N D-10396N6148NAll-In-Aviation LLC · Paragould, ARBuilt 1969 · S/N M-1225N6148XHrg3 LLC · Yuma, AZS/N E-3548N6149NZappa Tyler M · Hudson, FLBuilt 1969 · S/N M-1226N614BSPicton Jerry Francis · Rockport, TXBuilt 1975 · S/N TC-1917N614DBaggett William C · Lake Stevens, WABuilt 1951 · S/N D-2872N614LGleason Gregory C · Ennis, MTBuilt 1977 · S/N D-10055N614MMN9454h Inc · Wilmington, DEBuilt 1980 · S/N E-1735N614PKMeadowlake Airpark LLC · Lenoir City, TNBuilt 1961 · S/N D-6730N614PWAlpha Victor 8 LLC · Broken Arrow, OKBuilt 1982 · S/N M-2364N614TRyan James A · Needville, TXBuilt 1958 · S/N D-5473N614TMHallman David M Jr · Erie, PABuilt 1974 · S/N E-567N6150CNantucket Aviation LLC · Plymouth, MNBuilt 1981 · S/N E-1960N61526Mata Joseph F · E Setauket, NYBuilt 1982 · S/N M-2348N615ABBolea Air Inc · Morgan Hill, CABuilt 1964 · S/N TC-815N615AGAmala Andrew · Hollywood, MDBuilt 1973 · S/N CE-470N615QConroy John F · Brighton, COBuilt 1958 · S/N D-5443N615RMMann Robert F · Oshkosh, WIBuilt 1981 · S/N P-584N615VMBas Part Sales LLC · Greeley, COBuilt 1977 · S/N MC-480N6163RSai Flight Services Inc · Greer, SCBuilt 1981 · S/N E-1967N6164CN6164c LLC · Baker, LABuilt 1981 · S/N MC-769N616CDInnovative Aviation LLC · Filer, IDBuilt 1973 · S/N CE-455N616FAArnett Freddy H Jr · Yulee, FLFirst renewal noticeBuilt 1955 · S/N D-4081N616GROld Goat Aviation LLC · Chattanooga, TNS/N TJ-184N616JARegistered aircraftBuilt 1985 · S/N E-2285N616KCN616kc LLC · Conway, ARBuilt 1975 · S/N M-1726N616QMena Carlos T · Colorado Springs, COBuilt 1956 · S/N D-4900
Back to AD 99-05-13 R1 WD