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.

N2426JLewis Chad · Anchorage, AKBuilt 1979 · S/N 18-7909122N2427DWiplinger Charles · Inver Grove, MNBuilt 1979 · S/N 18-8009007N2428DLee Brenda T · Boonville, NYS/N 18-1934N2428MTyrrell Wesley F · Central, AKBuilt 1947 · S/N 12-1661N2429MTurner Greg W · Delta Junction, AKS/N 12-1663N2429SAdams Kelly M · Galveston, TXBuilt 1979 · S/N 18-7909148N2431ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 22-787N2431MSchroeder John · Anacortes, WABuilt 1947 · S/N 12-1675N2432HErsland Ryan Peter · Anchorage, AKBuilt 1979 · S/N 18-7909184N2432MBunce John · Canaan, CTS/N 12-1530N2432PUnruh Philip Trustee · Harper, KSBuilt 1955 · S/N 22-2803N2433ARyther John W · Austin, MNS/N 20-929N2435PGarst William P · Johnson City, TNBuilt 1955 · S/N 22-2806N2436ASandercock Mark L · Pewaukee, WIS/N 22-789N2438PDavey Kenneth E · Lake Crystal, MNBuilt 1955 · S/N 22-2809N2439MRegistered aircraftBuilt 1947 · S/N 12-1667N2439PNeal Christopher C · Staples, MNBuilt 1955 · S/N 22-2810N243AKHilwig Kara · Wasilla, AKBuilt 1989 · S/N 1809010N243CGTampa Bay Soaring Society · Zephyrhills, FLBuilt 1972 · S/N 25-5450N243SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1961 · S/N 22-8376N243THillestad Darrell · Aberdeen, SDBuilt 1953 · S/N 18-2357N2442MRegistration Pending · Sterling, AKRegistration pendingBuilt 1947 · S/N 12-1545N2443AGauthier Evans J · Mckinney, TXBuilt 1953 · S/N 22-1096N2444AHoward Nathan L · Fairbanks, AKBuilt 1952 · S/N 18-1939N2444JDavis Bret R · Boynton Beach, FLBuilt 1979 · S/N 18-7909124N2444MMerillat Anthony J · Adrian, MIBuilt 1947 · S/N 12-1682N2444PMcgowan Robert A · Burgaw, NCS/N 22-2815N2445AMcmillian Dean R · Wasilla, AKBuilt 1952 · S/N 18-1940N2445PBolivar Flyers Inc · Brighton, MOBuilt 1955 · S/N 22-2816N2446MCondor Aviation LLC · Bethlehem, PABuilt 1947 · S/N 12-1672N2447JSears James W Jr · Wasilla, AKS/N 18-7909125N2449PSchulze Thomas A · Bloomville, OHBuilt 1955 · S/N 22-2821N244AKRuckman Jim D Jr · Clarksville, TNBuilt 1982 · S/N 18-8209016N244CGEagle Sport Aviation Club Inc · De Leon Springs, FLBuilt 1968 · S/N 25-4734N24500Ophelia Air LLC · Cherry Hill, NJBuilt 1939 · S/N 3233N24502Puckett Trevor W · New Underwood, SDBuilt 1939 · S/N 3221N2450MProlagayev Sergey · Needville, TXBuilt 1947 · S/N 12-1537N2450PMerit Aviation LLC · Fort Myers Beach, FLBuilt 1955 · S/N 22-2823N2451MAccurate Aero LLC · Minden, NVBuilt 1947 · S/N 12-1536N24520Mcfetridge Anne S Trustee · Fabius, NYBuilt 1939 · S/N 4-634N24523Royal David T · Duluth, MNBuilt 1939 · S/N 4-632N2452PStichter Darin J · Wedderburn, ORFirst renewal noticeBuilt 1955 · S/N 22-2825N24533Mcdonald Brad C · Swanton, OHBuilt 1939 · S/N 4-636N24536Byers Steven J · San Diego, CABuilt 1939 · S/N 4-635N24550Registration Pending · Wasilla, AKRegistration pendingS/N 4-639N2455JMarsh Galen · Minot, NDBuilt 1979 · S/N 18-7909126N2455MArizona Soaring Inc · Maricopa, AZBuilt 1947 · S/N 12-1674N24564Lumland Properties LLC · Winchester, VABuilt 1939 · S/N 4-649N2456ADempsey Timothy P · Pacific, MOBuilt 1952 · S/N 22-796N2456JN2456j LLC · Erie, COBuilt 1979 · S/N 18-7909127
Back to AD 99-01-05 R1