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.

N4079DErnst Gregory R · Eagle Creek, ORBuilt 1957 · S/N 34779N4079PN4079p LLC · Peoria, AZS/N 23-1556N4079XRichardson Scott · Grapevine, TXBuilt 1970 · S/N 5179N4079ZNewton James K · Charles Town, WVBuilt 1963 · S/N 18-8093N407AFRuff Brent M · Santa Clarita, CABuilt 1966 · S/N 30-1285N407BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280937N407CBLanham Kelty R · Fresno, CABuilt 1974 · S/N E-511N407CDKelly George Sumner · Columbus, GABuilt 2004 · S/N 1005N407CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282444N407DMPhillips Consulting Group Inc · Wilmington, DEBuilt 1990 · S/N EA-507N407EBAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11438N407FAStratus Rr LLC · New Castle, DEBuilt 2025 · S/N 28020207N407FDVilkin Peter D · Palo Alto, CABuilt 1990 · S/N 772N407FRRich Carolyn A · Redondo Beach, CABuilt 1997 · S/N 17280234N407FTSlipstream Inc · Cincinnati, OHBuilt 1982 · S/N 28-8216216N407JCPlane Partners LLC · Newton, MABuilt 1982 · S/N E-2033N407MD9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12764N407MNMaldonado Leopoldo · Paramount, CABuilt 1983 · S/N 407N407PCOversquare LLC · Norman, OKBuilt 1996 · S/N E-3032N407RKMoore John C · San Miguel, CABuilt 1968 · S/N 401-0181N407RSSiddens Tab D · Albany, MOBuilt 1975 · S/N TH-593N407SGriffing Flying Service Inc · Port Clinton, OHBuilt 1979 · S/N 28-7990545N407SCAlpha Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12588N407TVolunteer Aerials LLC · Stanley, NCBuilt 1966 · S/N TE-231N407TLBas Part Sales LLC · Greeley, COBuilt 1970 · S/N 28R-7135013N407WBBad Dog Aviation LLC · Wasilla, AKBuilt 1963 · S/N 18-8085N407WYVerdoljak Corey · Homer, AKBuilt 1955 · S/N 18-4192N407XCallahan Ashton G · Homer, AKS/N 7041CN40801Island View Flying Club · Goleta, CAS/N 28-7410049N40806Sky Dream Flight School LLC · Dallas, GABuilt 1973 · S/N 28-7425169N4080DCrane Gary W · Gig Harbor, WABuilt 1957 · S/N 34780N4080SCosse John J Jr Trustee · Lenexa, KSBuilt 1975 · S/N D-9728N4080YPanama City Cycles Inc · Panama City, FLBuilt 1961 · S/N 1850280N4080ZVan Dyke Brian S · Rio Oso, CABuilt 1964 · S/N 18-8094N4081Pearl Equipment LLC · Bassfield, MSBuilt 2016 · S/N E-4081N40810Qualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 28-7415088N40812Dae Aviation Enterprises Corp · Gilford, NHBuilt 1973 · S/N 28-7405068N4081DEarl Tim G · Plymouth, CAS/N 34781N4081EOrlando Aircraft Sales LLC · Orlando, FLBuilt 1991 · S/N 1916N4081SScheerer Martin · Edina, MNBuilt 1974 · S/N 28R-7435130N40823Ashley Aviatrix LLC · Atlanta, GABuilt 1973 · S/N 28-7425173N40829Shively Ray F · Turtlepoint, PABuilt 1973 · S/N 28-7415090N4082BJdj Inc · Mountain Home, ARBuilt 1977 · S/N 77-30850N4082DSharp Nicholas · Valdez, AKBuilt 1957 · S/N 34782N4082JEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 1794N4082RMid-Life Crisis Aviation LLC · Renton, WABuilt 1968 · S/N 32-40398N4082XLeach Joey D · Flat Rock, INBuilt 1971 · S/N 5182N40830Spirit Of Rocky Mount LLC · Nashville, NCFirst renewal noticeBuilt 1973 · S/N 28-7415091N40836Hawkins Joshua L · Colbert, GABuilt 1973 · S/N 28-7425176N40838Andrews Mark F · Jacksonville, FLBuilt 1973 · S/N 28-7415093
Back to AD 2007-04-19 R1