OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,638

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.

N1620PNielsen Mona · Ford, WABuilt 1954 · S/N 22-2434N1625PGauthier Robert Jones · Melba, IDBuilt 1954 · S/N 22-2439N1627APlettner David C · Sutton, NEBuilt 1951 · S/N 18-1267N1627PMiller Wesley M · Crookston, MNBuilt 1954 · S/N 22-2441N162AWSchiller Gottfried · Englewood, FLS/N 18-8109082N162KMerge Mafia LLC · Wall, TXBuilt 1959 · S/N 18-7171N162LFFeick Larry E · Crestline, OHBuilt 1947 · S/N 11-162N1630PSmith Richard D · Williamstown, OHBuilt 1954 · S/N 22-2444N1632PWilley Larry E · Fremont, OHBuilt 1954 · S/N 22-2446N1636AHilliard John · Olympia, WABuilt 1952 · S/N 18-1281N163TKloes Michael L · Everett, WABuilt 1953 · S/N 18-2277N1642PBangerter Timothy W · Leoti, KSBuilt 1954 · S/N 22-2458N1643PPacer Air LLC · Wilmington, OHBuilt 1954 · S/N 22-2459N1645AHayden Aviation LLC · Rhome, TXBuilt 1952 · S/N 20-843N1646PGerigs Trucking And Leasing Inc · Hoagland, INBuilt 1954 · S/N 22-2462N1648ARenner Daniel T · Crooks, SDS/N 22-411N1649AHudgin James P · Lewisburg, TNBuilt 1952 · S/N 22-412N1649BBurke Cary C · Lake Stevens, WAS/N 22-2037N1649PSutton Aircraft Salvage LLC · Palmer, AKBuilt 1954 · S/N 22-2465N1650PChilcote Gary D · Britt, MNBuilt 1954 · S/N 18-3765N1651PCaron Ty · Redmond, ORBuilt 1954 · S/N 18-3766N1652PCcf Ventures Inc · Bangor, MEBuilt 1954 · S/N 18-3767N1653PAirmotive Service LLC · Brigham City, UTBuilt 1954 · S/N 18-3768N1655AConnell Romeao J · Gresham, ORS/N 22-419N1658PSmith Gregory · Lewistown, MTBuilt 1954 · S/N 18-3780N1659ARowell Tony A · Westerville, OHBuilt 1952 · S/N 22-415N165PRGrove Robert P · Jamul, CAS/N 18-5383N165TGrove Robert P · El Cajon, CABuilt 1953 · S/N 18-2279N1660PJanvrin Jerry M · Buffalo, SDBuilt 1954 · S/N 18-3782N1661PFrost John David Trustee · Anchorage, AKBuilt 1954 · S/N 18-3783N1662PRyan Dietrich Farms Inc · Scottsbluff, NEBuilt 1954 · S/N 18-3784N1663POakes Stephen · Joshua Tree, CAS/N 22-3089N16686Smith A J · Oneill, NES/N 11-JRS-3N16688Water Wings LLC · Buckley, WAS/N 18-875N1668PProfessional Pilots Inc · Lowell, INBuilt 1955 · S/N 18-3797N166TBuechle Tim P · Talkeetna, AKBuilt 1953 · S/N 18-2280N1672PAkchak Air LLC · Leeds, UTBuilt 1954 · S/N 18-3801N1673ASheeley Patrick D · High Falls, NYBuilt 1952 · S/N 22-436N1674LWhalen Patrick M · Anchorage, AKS/N 18-7609093N1679ARostron Christopher M · Kokomo, INS/N 22-441N1679PClearwater Potlatch Timber Pa · Orofino, IDBuilt 1954 · S/N 18-4068N167RMSellman Richard · Chadron, NEBuilt 1967 · S/N 18-8514N167TTouchstone Gwendolyn M · Villa Rica, GABuilt 1953 · S/N 18-2281N1680APaprocki Jason C · Fairplay, COS/N 20-842N1681PWarner Philip · San Marcos, CABuilt 1954 · S/N 22-2467N1682AMackie Scott B · Woodstock, GABuilt 1952 · S/N 20848N1684PTharpe George W · Street, MDBuilt 1955 · S/N 22-2470N1685PMckinney Derrill L · Rio Linda, CABuilt 1954 · S/N 22-2471N1687PSofia De Venecia LLC · Southampton, NYBuilt 1954 · S/N 22-2473N168DMarolf Duke · Seward, AKBuilt 1963 · S/N 18-8293
Back to AD 99-01-05 R1