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.

N621GWoolslayer Homer · Tulsa, OKBuilt 1966 · S/N TE-214N621QHazell Samuel P · Oceanside, CABuilt 1957 · S/N D-5255N621RHSchiffer Herbert · West Chester, PABuilt 1991 · S/N E-2654N621WBRicky Bobby USA LLC · Kalispell, MTS/N P393N6222MBeech Club LLC · La Crosse, INBuilt 1967 · S/N D-8545N62254Richard Nestor · Boise, IDS/N TJ-431N6229VBoyes Robert L · Benton City, MOBuilt 1967 · S/N TG-43N6231AEtzelmiller Arjay J · Lincoln, NEBuilt 1981 · S/N E-1983N6233GFlying Cardinals Aircraft Group Inc · Stow, MABuilt 1981 · S/N E-1984N6233XRdm Ventures LLC · Buckhead, GABuilt 1982 · S/N E-1988N6234ZBruce Bullock · West End, NCBuilt 1981 · S/N E-1985N62379Sullivans Island Aerospace LLC · Sullivans Island, SCBuilt 1982 · S/N E-2007N62384Watson James E Jr · Victor, COBuilt 1948 · S/N D-1917N6238VTurner James D · Duvall, WABuilt 1967 · S/N D-8588N623CSReigle Aviation South LLC · Orlando, FLBuilt 1960 · S/N D-6360N623MHBearden George F Jr · Weatherford, TXBuilt 1989 · S/N CE-1364N623TImmigration Aero LLC · Lewes, DEBuilt 1958 · S/N D-5768N6240VRegistered aircraftBuilt 1967 · S/N D-8628N6243VManning William O Trustee · High Point, NCBuilt 1967 · S/N D-8585N6247VNichols Mark W · St Pete Beach, FLBuilt 1967 · S/N D-8614N624DHand James Kevin · Alton, ILBuilt 1951 · S/N D-2884N624DKFw Cielo LLC · Canton, OHBuilt 1976 · S/N D-9879N624NPHackett Stevan S · Jacksonville, ILBuilt 1969 · S/N D-9010N624QDuea James G Trustee · Oklahoma City, OKBuilt 1957 · S/N D-5258N624TBozarth Rodney E · Henderson, KYBuilt 1957 · S/N D-5321N6252VJansen Vic C · Moses Lake, WABuilt 1967 · S/N TG-49N6254NCoil Construction Inc · Columbia, MOBuilt 1981 · S/N E-1989N6255BRogers Aeronautics LLC · Lake Barrington, ILBuilt 1981 · S/N E-1990N6255JAzimuth Aviation LLC · Mechanicsburg, PABuilt 1996 · S/N E-3019N625DButcher Daniel E · Marietta, OKS/N D-2885N625LMDsb Investments LLC · Dodge City, KSBuilt 1991 · S/N CE-1600N625SGoldman Ryan · Cordova, TNBuilt 1972 · S/N TE-881N6260VPcb Aircraft · Johnstown, OHBuilt 1967 · S/N D-8591N6261KGlasmon Inc · Nacogdoches, TXBuilt 1981 · S/N E-1993N6261VSundance Air Service Inc · Alameda, CAS/N D-8593N6262VGk Ag LLC · Broxton, GAS/N D-8592N6263VJansen Aviation Services And Sales LLC · Monticello, IABuilt 1967 · S/N D-8594N6264VHagstrom Christopher · Sauk Centre, MNBuilt 1967 · S/N D-8596N6265VFankhauser Thomas D · Montgomery, TXBuilt 1967 · S/N D-8595N6266NSai Flight Services Inc · Greer, SCBuilt 1982 · S/N E-2001N6267XWahlen Per · Newtown Square, PABuilt 1982 · S/N D-10391N6269VGopher One LLC · Willernie, MNBuilt 1967 · S/N D-8598N626CRSmiles Aviation LLC · Kerrville, TXBuilt 1978 · S/N E-1367N626HRegistered aircraftBuilt 1966 · S/N TC-980N626NDay William B · Conroe, TXBuilt 1980 · S/N P-545N626PRai Aviation LLC · Athens, GAS/N E-3552N626SKelly Kendall J · Mckinney, TXBuilt 1966 · S/N D-8052N6276VHilsenroth Robert · Fernandina Beach, FLBuilt 1967 · S/N D-8603N6277VBlue Jay Aviation · Lake Placid, FLS/N D-8601N6278VMontana Excursions LLC · Modesto, CABuilt 1968 · S/N D-8602
Back to AD 99-05-13 R1 WD