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.

N6CLRegistration Pending · Phoenix, AZRegistration pendingBuilt 1953 · S/N G-154N6CNNearburg Charles E · Dallas, TXBuilt 1955 · S/N G-736N6DHHackler Dane · Hemet, CABuilt 1972 · S/N CE-397N6ED3 Rivers Inc · St George, UTS/N TJ-9N6FQualitair LLC Trustee · MichelstadtBuilt 1955 · S/N D-4368N6FBTotman Darwin L Jr · Montgomery, LABuilt 1978 · S/N E-1318N6FCMerriam Lowell G · Chowchilla, CAS/N D2461N6GFFrodel Greg W · Pasco, WABuilt 1991 · S/N E-2657N6HHHansen Mike D · Spicewood, TXBuilt 1962 · S/N D-6928N6JCRaa Investments LLC · Albertville, ALBuilt 1982 · S/N CE-994N6JKMatissek Joseph G · New Port Richey, FLBuilt 1964 · S/N D-7577N6JTBandy Steven Trustee · Marana, AZBuilt 1979 · S/N E-1565N6KBrewer Aviation LLC · West Fork, ARBuilt 1969 · S/N TC-1254N6KGSelect Aerospace Industries Inc · Weyers Cave, VAS/N BG-250N6LS9 Seconds Consulting LLC · Wellington, FLBuilt 1981 · S/N TE-1186N6LWN195sd LLC · Senatobia, MSBuilt 1975 · S/N P-323N6MYPruitt Robert G · Russellville, ARS/N D-8107N6MZWalters Glenn L · Triadelphia, WVBuilt 1988 · S/N CE-1244N6QKRobb Jeffery A · Hebron, OHBuilt 1982 · S/N WA-306N6RHDill Steven Vaughn · Lenoir City, TNBuilt 1959 · S/N D-6200N6RMHarper Bryan K · Junction City, ORBuilt 1964 · S/N D7411N6SVFaivre Anthony L · Hampshire, ILBuilt 1969 · S/N D-8917N6THDouble I Flyers Inc · Wilmington, DEBuilt 1974 · S/N D-9622N6TXPrillinger Richard J · Redwood City, CABuilt 1973 · S/N TC-1598N6WFAxis Equipment LLC · Fuquay Varina, NCBuilt 1964 · S/N TC-794N6WKSushi Aviation Holdings LLC · Raleigh, NCBuilt 1976 · S/N E-807N6XZKahler Automation Corp · Fairmont, MNBuilt 1982 · S/N E-2047N6ZMStauf Air LLC · Germantown, TNBuilt 1990 · S/N E-2574N7000QRegistered aircraftS/N D-7000N7002NBfr Racing Inc · Monticello, ARBuilt 1967 · S/N D-8613N700AVYates Melvin Jones · Duck River, TNBuilt 1973 · S/N TC-1519N700BDonnell James C · Crowville, LABuilt 1948 · S/N D-1703N700BTHogan Christopher S · Colorado Springs, COBuilt 1966 · S/N D-8076N700DCSwanson David R · Isanti, MNBuilt 1977 · S/N E-1132N700DNJohnson Bruce W · Portland, ORBuilt 1965 · S/N TC-967N700EDMcd Aviation Inc · Wilmington, DEBuilt 1972 · S/N D-9372N700MWSome Beech LLC · Bolivar, MOBuilt 1978 · S/N ME-134N700NCook Charles N · Lakeside, TXBuilt 1949 · S/N B-19N700RCUniversal Aviation LLC · Decatur, ARBuilt 1991 · S/N E-2606N700SSBullard Franklin C · Ormond Beach, FLS/N E-1248N700TNInternational Air Services Inc Trustee · Carson City, NVBuilt 1964 · S/N BA-718N700VRMountain & Vine LLC · Park City, UTBuilt 1979 · S/N TJ-194N7014CAct Aviation LLC · Oxford, MSBuilt 1979 · S/N CE-883N7016NN7016n LLC · Columbia, MOBuilt 1967 · S/N D-8649N7017NSalinas Nursery Inc · Fresno, CABuilt 1967 · S/N TE-484N7018NLawless Van N Jr · Mooresville, NCBuilt 1967 · S/N D-8618N701MEGofly Trading LLC · Opa Locka, FLBuilt 1968 · S/N TC-1159N7020NRanchn Air LLC · Fort Collins, COBuilt 1967 · S/N TE-468N7021NRobertson Eric A · Knoxville, TNBuilt 1967 · S/N D-8620N7023NSteria Kermit J · Monahans, TXBuilt 1967 · S/N D-8627
Back to AD 99-05-13 R1 WD