OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,639

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-01-05-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:99-01-05-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.

N3661PBradham David T · Kenai, AKBuilt 1955 · S/N 22-3412N3662MKerzen Properties LLC · Fayetteville, ARBuilt 1947 · S/N 12-2613N3662NLarsen Kevin L · Firth, IDBuilt 1947 · S/N 12-1913N3662ZDaniel Dario M · Charlotte, NCBuilt 1960 · S/N 22-7560N3664ARegistration Pending · Taylorsville, KYRegistration pendingBuilt 1954 · S/N 22-1924N3665ADaffron Rodney · Ragland, ALBuilt 1954 · S/N 22-1925N3665MErnie Hall Aviation Museum Inc · Warren, OHBuilt 1947 · S/N 12-2530N3665PHarness Jesse J · Peoria, AZS/N 18-4621N3665RDomke Kenneth M · Soldotna, AKBuilt 1954 · S/N 18-4112N3666MLarson Samuel T · Anchorage, AKS/N 12-2616N3666ZWedepohl Richard · Madison, WIBuilt 1960 · S/N 22-7564N3667NLong Michael C · Seattle, WABuilt 1946 · S/N 12-1918N3667PSlofly LLC · Red Lodge, MTBuilt 1955 · S/N 18-4624N3668NConnors Sean P · Tampa, FLS/N 12-1919N3668ZYork Matthew J · Waterloo, ILS/N 22-7566N3669AFadenrecht Joe D · Cashmere, WABuilt 1953 · S/N 22-1928N3669MMitrzyk Gary L · Anchorage, AKBuilt 1947 · S/N 12-2621N3669NMcdonald Douglas E · Deering, NDBuilt 1947 · S/N 12-1920N3670NMcmanigle Jeffrey M · Osakis, MNBuilt 1946 · S/N 12-1921N3670ZFaught Jeffrey R · Bismarck, NDBuilt 1960 · S/N 22-7408N3671NTin Cup Aviation LLC · Lakeland, FLBuilt 1947 · S/N 12-1922N3671ZYedinak Jeremy W · Blackstone, ILS/N 18-7394N3672MTyrrell Luke L · Fairbanks, AKBuilt 1947 · S/N 12-2533N3672PSinnott-Simonis Lyle · Girdwood, AKBuilt 1955 · S/N 18-4571N3673AKrehbiel David E · Hastings, MNBuilt 1953 · S/N 22-1932N3673PWikle Lori Ann · Glennallen, AKBuilt 1955 · S/N 18-4572N3673ZMcmahan Harley B · Gakona, AKBuilt 1960 · S/N 18-7398N3674MHunt James D · Seneca, SCFirst renewal noticeBuilt 1947 · S/N 12-2624N3674ZLohse William F · Carter, MTBuilt 1960 · S/N 18-7399N3675MSchwietz Thomas · Strasburg, VAS/N 12-2625N3675ZStangel Richard C · Enterprise, ORBuilt 1960 · S/N 18-7401N3676ATomes William H · Buffalo, KYBuilt 1953 · S/N 22-1935N3676NAbrams John E · Eagle River, AKBuilt 1947 · S/N 12-1927N3676PThomas Steve L · Presho, SDBuilt 1956 · S/N 18-4575N3676ZWhisair LLC · Little Rock, ARBuilt 1960 · S/N 18-7402N3677AWing LLC · Sterling, AKBuilt 1953 · S/N 18-3072N3677MKetchum Jeremy W · Wasilla, AKBuilt 1947 · S/N 12-2531N3677PZimmerman Harvey · Shelby, OHBuilt 1956 · S/N 18-4576N3677ZSims Doyle B · Mcgehee, ARBuilt 1960 · S/N 18-7404N3678PFriemel & Sons LLC · Groom, TXS/N 18-4578N3678ZNorris Joseph B · Oshkosh, WIBuilt 1960 · S/N 18-7405N3679PFountain Craig T · Moscow, IDBuilt 1954 · S/N 18-4580N367XWBold Group Ltd · Englewood, COS/N 22-1187N3680MStadman Tyrel W · Eagle River, AKBuilt 1947 · S/N 12-2631N3680PHyde Michael L · La Porte, TXBuilt 1955 · S/N 18-4581N3680ZDriskell James P · Anchorage, AKBuilt 1960 · S/N 18-7409N3681NCange Shawn · Anchorage, AKS/N 12-1931N3681ZDickson Robert T · Charlotte, NCBuilt 1960 · S/N 18-7410N3682PDaily John F · Chugiak, AKBuilt 1955 · S/N 18-4583N3683MEverett Frank M · Wasilla, AKBuilt 1947 · S/N 12-2633
Back to AD 99-01-05 R1