OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,428

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:2007-04-19-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:2007-04-19-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.

N12KCHeath David A Trustee · Cottonwood, AZBuilt 1965 · S/N D-7867N12KDDeeble Kenneth M · Dayton, MTBuilt 1979 · S/N 596-80N12KFN12kf LLC · Pass Christian, MSBuilt 1973 · S/N 21059853N12KMFitzmaurice Productions Inc · Fawnskin, CABuilt 1977 · S/N 18265774N12KSWalton Cheryl H · Indianapolis, INBuilt 1974 · S/N TE-1005N12LGLapiair LLC · Vergennes, VTBuilt 1998 · S/N 20418N12LMHaney Andrew J · Mt Morris, PAS/N 1001N12LPBlewett John Thomas Jr · Springfield, GABuilt 1998 · S/N 21056CN12LRBalk Martin · Warren, NJBuilt 1978 · S/N 18266528N12LTBaker William A · Lincolnton, NCBuilt 1972 · S/N 406N12LZConlon Joseph F · Gainesville, FLBuilt 2011 · S/N LZ001N12MFitzpatrick H Mike · Cleveland, GABuilt 2010 · S/N 60548N12MBHarrison Hayden F · Mckean, PAS/N 1948N12MJCruiseair Aviation Inc · Ramona, CABuilt 1972 · S/N 17261299N12MPMarcus Robert L · Dallas, TXBuilt 1963 · S/N 30-284N12MTRegistration Pending · Mount Vernon, IARegistration pendingBuilt 1978 · S/N TC2119N12MVKarduck Craig · Morgan, UTS/N 3671N12NMPlane Fun Inc Tr Trustee · Snellville, GABuilt 2006 · S/N 0036AKN12PShalun Lukas A · Germantown, TNBuilt 1977 · S/N 001N12PFRucker Gary R · Kingman, AZBuilt 1977 · S/N 21062401N12PKDuncan Aviation Inc · Lincoln, NEBuilt 2000 · S/N 2103N12PMFlying Bald Eagles Inc · New Lenox, ILBuilt 1964 · S/N D-7514N12PNRegistration Pending · Maitland, MORegistration pendingBuilt 1998 · S/N 1243-98N12PUMeyer Daniel B · Redding, CABuilt 1998 · S/N 008N12PVShoreline Assets LLC · Ashland, ORBuilt 2007 · S/N E-3799N12PWOhio State University College Of Engineering · Columbus, OHBuilt 1972 · S/N 21059796N12PXMvs Air LLC · Kalispell, MTS/N 61P-0524-220N12PZA5 Flight Club LLC · Saint Cloud, FLBuilt 1974 · S/N AA5-0622N12QHawkes F Bryant · Lake Dallas, TXBuilt 1966 · S/N 401-0014N12QRWilson Koby D · Southside, ARBuilt 2000 · S/N 2121N12QWAll Aviation LLC · Tucson, AZBuilt 1984 · S/N 5053N12RDoll John M · Austin, TXBuilt 1976 · S/N 0744N12RCSkipper Thomas · Coburg, ORS/N D-9308N12RDFlying Colors Airparts Inc · Leesburg, FLBuilt 1958 · S/N 24-368N12REWilliams Jeffrey · Georgetown, INBuilt 1982 · S/N EPPLETT-0001N12RFMckay Jonathan S · Chesapeake, VAS/N 21057612N12RHLead Aviation Fl1 LLC · Osprey, FLBuilt 2015 · S/N 13842N12RZZapsky Richard M Jr · Houtzdale, PABuilt 2000 · S/N 5585N12SBSilvano Sal · La Grange, KYBuilt 1979 · S/N 340A0911N12SDStevens Sam D · Isola, MSBuilt 1973 · S/N 1376N12SFToller Rick L · Crescent City, FLBuilt 1977 · S/N 814N12SVHarmacinski Larry Trustee · Punta Gorda, FLBuilt 1947 · S/N 418N12TASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1958 · S/N 22-6319N12TCCb22 Holdings LLC · Price, UTBuilt 1977 · S/N 28-7790417N12TESchwigen Justin R · Alton, ILBuilt 1998 · S/N 1440N12TLLoofbourrow Travis S · Houston, TXBuilt 1968 · S/N 60N12TPTravels With Trip LLC · Lewes, DEBuilt 1961 · S/N D-6710N12TQWyoming Aeroflight LLC · Laramie, WYBuilt 1994 · S/N 1270N12TRRegistered aircraftBuilt 1991 · S/N 10053N12TTThoms Robert D · Clyde, MIS/N 310H0066
Back to AD 2007-04-19 R1