AD 2007-04-19 R1

Registered aircraft · 108,434

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.

N311SKDoyle Thomas Michael · New City, NYBuilt 1976 · S/N 310R0687N311SSSeabolt Pilots LLC · Cave City, ARBuilt 1960 · S/N 24-1959N311TLM & N Enterprises LLC · Topeka, KSBuilt 1981 · S/N 18267937N311XStevens Adam · Dacono, COBuilt 1963 · S/N 2592N311ZRegistration Pending · Rockford, ILRegistration pendingBuilt 1960 · S/N CD-222N31200N7775mw LLC · Sand Lake, MIBuilt 1995 · S/N 20036CN3120FLengyel Roger · Santa Fe, NMBuilt 1966 · S/N 18257220N3120MCowtown Aviation LLC · Aledo, TXBuilt 1987 · S/N CE-1204N3120QLinda In The Sky LLC · Webster, MNBuilt 1967 · S/N 18258120N3120RBulang Investments LLC · Newbury, NHS/N 18258520N3120WWiese Chuck F · Portland, ORBuilt 1973 · S/N TC-1645N3120ZGifford Thomas Lloyd · Canadian, TXS/N 22-7065N31216Valley Aire Inc · Marlboro, NYBuilt 1975 · S/N 290N3121DFrey Jerry P · Fallon, NVBuilt 1955 · S/N 31919N3121FLily Chris H · Ocala, FLBuilt 1966 · S/N 18257221N3121LBeckham Stephen · Canby, ORBuilt 1991 · S/N 2309N3121THall Tyler · Billings, MTS/N 17700421N3121VCochise Community College · Douglas, AZBuilt 2006 · S/N 2843626N3121WAlpha Dog Aviation LLC · Marco Island, FLBuilt 1973 · S/N TH-410N31228Hauser Dean · Stratford, TXBuilt 1993 · S/N 21002CN3122EKantec Inc · Cary, NCBuilt 1999 · S/N 2843250N3122LE C G Aviation Inc · Orange, CABuilt 1965 · S/N 310J0122N3122MMiller-Jackson Co Inc · Oklahoma City, OKBuilt 1984 · S/N EA-416N3122RMarrow Henry G · Southern Pines, NCBuilt 1994 · S/N TH-1722N3122STecumseh Skydiving School LLC · Tecumseh, MIBuilt 1964 · S/N 18255622N3122UTravel Aviation Inc · Vineyard Haven, MABuilt 1988 · S/N E-2431N3122YJti Management LLC · Colfax, WAS/N 18254122N3123CRmc Aviators LLC · Wilmington, DEFirst renewal noticeBuilt 1954 · S/N 30922N3123EKanase Padmaneel B · Amarillo, TXS/N 17271444N3123QDarkhorse Six Inc · Boerne, TXBuilt 1967 · S/N 18258123N3123RHs Aviation Holdings LLC · Eagle, IDBuilt 1967 · S/N 18258523N3123SGabin LLC · Tulsa, OKBuilt 1964 · S/N 18255623N3123WSullivan Dan · Kingwood, TXBuilt 1973 · S/N E-500N3123YAbecca Corporation · Jackson, MIBuilt 1962 · S/N 18254123N3123ZTripp Robert L · Walsenburg, COBuilt 1959 · S/N 22-7068N31241Hotel Charlie Aero LLC · Marshville, NCBuilt 2006 · S/N 3246234N3124DBurch David C · Flushing, MIBuilt 1955 · S/N 31922N3124FTrue Aviators LLC · Kiowa, KSBuilt 1966 · S/N 18257224N3124RMidland Liberty LLC · Midland, MIBuilt 1967 · S/N 18258524N3124VBonanza/Baron Museum Staggerwing Museum Foundation · Tullahoma, TNBuilt 1962 · S/N SV-109-D549N3124WBaron 24w LLC · Outing, MNBuilt 1973 · S/N TH-411N31252Buchholz Claus W · Haslett, MIBuilt 1972 · S/N 249-72N31256Mason Crosby H · Zebulon, NCBuilt 1972 · S/N 330-72N31257Lea Nathan · Belgrade, MTBuilt 1972 · S/N 400-72N3125DDavis Ronald L Jr · Soldotna, AKBuilt 1955 · S/N 31923N3125FHall Aircraft LLC · Kenai, AKS/N 18257225N3125LOxley Lake Solutions LLC · Lawton, MIBuilt 1965 · S/N 310J0125N3125QSunrise Aviation Llp · Gig Harbor, WABuilt 1967 · S/N 18258125N3125THamilton Brian H · Currie, MNBuilt 1967 · S/N 17700425N3125UAlba Leasing Services LLC · Scottsdale, AZBuilt 2006 · S/N 11369
Back to AD 2007-04-19 R1