OpenAirDocs.org
AD 2003-13-15 R1

Registered aircraft · 330

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:2003-13-15-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:2003-13-15-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.

N8835FUniversal Exports LLC · Schuylkill Haven, PABuilt 1963 · S/N 0198N8836FWooding William W · Anacortes, WABuilt 1963 · S/N 43-0196N8840FPinchorski Ronald G · Wiconisco, PABuilt 1963 · S/N 33-0185N8845FDowning Darrell W · Drakesville, IABuilt 1963 · S/N 53-0208N8856FRotorcraft Unlimited LLC · Brooksville, FLS/N 43-0194N8863FCain James W · Big Rapids, MIS/N 63-0243N8866FReynolds Darryl G · Wills Point, TXBuilt 1969 · S/N 0242N8871FGarvey Michael · Leesville, SCBuilt 1963 · S/N 0235N8872FCameron William Douglas Jr · Lexington, VAS/N 63-0238N8887FNiec Steven M · Clio, MIBuilt 1963 · S/N 73-0263N8891FDetgen Jim · Traverse City, MIS/N 83-0266N8901FBrookside Aero LLC · Grants Pass, ORS/N 0278N8911FA And J Aviation Services LLC · Titusville, FLS/N 0230N8913FLay Jerry K · Minonk, ILBuilt 1963 · S/N 93-0287N8925FAztec Aviation · Geneseo, ILBuilt 1964 · S/N 0307N8928FDenver Aerospace Science Museum · Watkins, COBuilt 1964 · S/N 0004N8938FSouthern Cross Aviation Inc · Wilmington, DEBuilt 1964 · S/N 44-0009N8944FFitzgerald Brian B · Gettysburg, PAS/N 15-0021N8948FO Reilly Thomas P · Oscoda, MIBuilt 1965 · S/N 15-0024N8950FAloft · Haiku, HIS/N 15-0026N8962FEmbry Aero Ltd · Greenville, ILBuilt 1973 · S/N 430196N8973FAvelan Enterprises Inc · Elm Grove, LABuilt 1973 · S/N 430195N8990FDeon Esterhuizen Inc · Clearwater, FLBuilt 1974 · S/N 640313N8SLLauff Samuel Jr · Ocala, FLS/N 570713N90270Dunn Larry W · Anderson, SCBuilt 1966 · S/N 66-18283N90271Gartman Jerald B · Morehead City, NCBuilt 1965 · S/N 65-18261N90586Lauff Samuel Jr · Ocala, FLS/N 64-18014N9061RCavender Matt · Howe, TXBuilt 1967 · S/N 47-0696N9061SObrien Derrick P · Lehigh Acres, FLS/N 76-0609N9064SCain James W · Big Rapids, MIS/N 36-0488N907ALTjm Ventures Inc · Rio Verde, AZBuilt 1996 · S/N S1742N911THDagnon Scott R · Driggs, IDBuilt 1969 · S/N 291093N911VCDetgen Ernest J · Carmen, OKBuilt 1965 · S/N 124-0144N9282FBox Helicopters Inc · Cotulla, TXBuilt 1974 · S/N 340289N9286FFlying High Like A Bird In The Sky · Longwood, FLBuilt 1974 · S/N 1040368N9291FHealey David A · Hammondsport, NYBuilt 1975 · S/N 850428N92PCEnright Arne P Trustee · Ward Cove, AKBuilt 1980 · S/N 1290867N931CPTriggs Andrew · Las Vegas, NVS/N S1652N9323FCouch Bill A · Palestine, TXBuilt 1964 · S/N 24-0025N9326FLelys · Orland, CABuilt 1964 · S/N 24-0031N9333FFire Bird Aviation Inc · Vivian, LABuilt 1964 · S/N 34-0040N9333VFletcher Jeffrey A · Belle Chasse, LABuilt 1963 · S/N 53-0207N9350FSale Reported · Perry, GASale reported, pending cancellationBuilt 1964 · S/N 0045N9361FRmw Services LLC · Mckee, KYBuilt 1964 · S/N 54-0082N9369FSauer David A · Palmetto Bay, FLBuilt 1964 · S/N 44-0070N9374FPierson Robert N · Nora, MNBuilt 1964 · S/N 54-0086N9385FReynolds Darryl G · Wills Point, TXBuilt 1964 · S/N 74-0112N9390FPennington Mitchell T · Medley, WVS/N 74-0114N9423FAvex Holdings Heli Inc · Lewes, DEBuilt 1965 · S/N 65-0207N9428FBargo Aviation Services LLC · Crittenden, KYBuilt 1965 · S/N 0175
Back to AD 2003-13-15 R1