OpenAirDocs.org
AD 2001-10-08

Registered aircraft · 60

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:2001-10-08')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-10-08')
  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.

N1000ALewis Steven G · Salida, COBuilt 1978 · S/N 3255N100XLLaitinen David P · Raleigh, NCBuilt 1979 · S/N 3401N101FHBadzelewicz-Hartl Irena · Scotch Plains, NJBuilt 1981 · S/N 4083N120RSRamsden Graham P · Omaha, NEBuilt 1981 · S/N 4092N13HHJames L Wallis · Davis, CABuilt 1983 · S/N 4204N13TBCcsc Ls3 LLC · Oakwood, OHBuilt 1977 · S/N 3292N144LSCulp John M · Asheville, NCBuilt 1985 · S/N 4481N177SSKrautter David L · Long Beach, CABuilt 1993 · S/N 6306N216TPTalarek Eva · Far Hills, NJBuilt 1977 · S/N 3073N23NHPinney Charles W · Tucson, AZBuilt 1982 · S/N 4205N241UKHingst Douglas J · Rcho Sta Marg, CABuilt 1982 · S/N 4199N26XCangahuala Laureano A · Claremont, CABuilt 1977 · S/N 3002N27DCPautz Martin R · Alpharetta, GABuilt 1978 · S/N 3306N2YASmith Daryl N · Coventry, CTBuilt 1981 · S/N 4093N30HHHayter Jr Henry W · Burlington, KYS/N 4026N30RDMid-Atlantic Soaring Assoc · Frederick, MDBuilt 1982 · S/N 4209N3252ZShugg Gregory G · Flagler Beach, FLS/N 4206N32JKSamson Philip C · Nashville, TNS/N 3102N370JSJuliet Sierra LLC · Falls Church, VABuilt 1984 · S/N 4370N402KBlace Mark P · Spring Gap, MDBuilt 1981 · S/N 4009N40HWBurrows Erik · Lake Forest, CABuilt 1978 · S/N 3279N40WCGrinder Michael C · Fairfield, PABuilt 1981 · S/N 4096N41XXWelborn Matthew T · Pfafftown, NCBuilt 1980 · S/N 4007N4204CUsher John R · Alcoa, TNBuilt 1981 · S/N 4088N427JDavenport Kira L · Malta, NYS/N 4095N42NSWright Robert L · Albuquerque, NMBuilt 1981 · S/N 4082N440BHPundole Faraidoon N · Sugar Land, TXS/N 4098N44SLArmor John A · Villa Hills, KYBuilt 1981 · S/N 4197N45EWDoherty Mark R · Pryor, OKBuilt 1978 · S/N 3224N45THLane Christopher W · Conroe, TXBuilt 1981 · S/N 4085N465CBTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1983 · S/N 4339N46895Westenfelder Christof · Salt Lake City, UTS/N 3199N48CWHibbard Bruce A · Layton, UTBuilt 1977 · S/N 3196N49EHPoling David R · West Chester, PAS/N 4005N4EHHealy Richard A · Chatham, NJBuilt 1977 · S/N 3028N511YRoeske Stanley B · Albuquerque, NMBuilt 1978 · S/N 3275N51801Templin Robert S · Stanhope, NJS/N 3197N52ABMead Colin E · Jacksonville Beach, FLBuilt 1980 · S/N 4006N52BWNeilson William Andrew · Louisa, VABuilt 1977 · S/N 3198N54LSShugg Mark D · Merritt Island, FLBuilt 1980 · S/N 4075N565NMckerlie Charles · San Diego, CABuilt 1985 · S/N 4503N573JLWood Thomas Edwin Jr · Steamboat Springs, COBuilt 1978 · S/N 3313N595ERClark Ronald L · Marysville, WABuilt 1977 · S/N 3046N60LSBravo Charlie Soaring LLC · Port Matilda, PABuilt 1983 · S/N 4192N64LSSeifried Paul E · Branchville, NJBuilt 1983 · S/N 4299N65LSPruitt Paul N · Santa Barbara, CABuilt 1983 · S/N 4353N65RBGrandbear Air LLC · Morgan, UTBuilt 1982 · S/N 4208N707JEFrias Roberto J · Steamboat Springs, COBuilt 1978 · S/N 3225N71JFeldvebel Tom P · Albuquerque, NMBuilt 1978 · S/N 3254N74KHHoover Wayne C Jr · Lawrenceville, GABuilt 1985 · S/N 4511
Back to AD 2001-10-08