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.

N3179FMoran Peter J · Como, MSBuilt 1966 · S/N 18257279N3179LPeregrine Aviation LLC · Oro Valley, AZBuilt 1965 · S/N 310J0179N3179ULawson John A · Lott, TXBuilt 1995 · S/N 20028CN3179YWolstein Joe M · Bigfork, MTBuilt 1962 · S/N 18254179N317ACChickenhawk Inc · Wilmington, MABuilt 1975 · S/N 17265537N317AJHibpshman Albert · Gilbert, SCBuilt 2003 · S/N 7075N317BDRegistered aircraftBuilt 1967 · S/N TE-317N317BFBoldflight LLC · Greenwood, INBuilt 1979 · S/N 28-7990428N317BLCowboy Aviation LLC · Edmond, OKFirst renewal noticeBuilt 2020 · S/N 172S12466N317BTAmerican Aircraft Brokers LLC · Aurora, ORBuilt 2005 · S/N 172S9828N317CAspn Aero LLC · Ostrander, OHBuilt 1995 · S/N EA-574N317CDBluecore Leadership LLC · Reston, VABuilt 2004 · S/N 0905N317CHCrestair Air LLC · Dover, DEBuilt 1973 · S/N D-9543N317CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12515N317DKKragnes David J · Felton, MNBuilt 1983 · S/N 247N317DSRucker Edward A · Longview, TXS/N 1294N317EPerkins Kevin J · Wichita Falls, TXBuilt 2022 · S/N 40740N317EPMcelligott Michael J · Woodstock, VABuilt 1969 · S/N D-9044N317GKPeterson Kurtley D · Centerfield, UTBuilt 1999 · S/N 2011N317HDHardrock Drilling LLC · Francesville, INBuilt 2026 · S/N 18283339N317HMSplendid Aviation-Victoria LLC · Corpus Christi, TXBuilt 1966 · S/N 28-3734N317JKKress Dagmar · Parker, COBuilt 2008 · S/N 6081N317JRUnd Aerospace Foundation · Grand Forks, NDBuilt 2010 · S/N 1105-2011N317KAWycka Michelle Sarah · Stayton, ORS/N 18254317N317LAviation Adventures And Publications Inc · Wilmington, DEBuilt 1961 · S/N 310-0126N317LBTrail Of 140 Tears LLC · Bozeman, MTBuilt 1970 · S/N 28-26935N317MARegistration Pending · Craig, MORegistration pendingBuilt 2013 · S/N 3185N317RDelaney Jeffrey Stephen · Arlington, TNBuilt 2003 · S/N 0495N317RJN317rj Inc · Maitland, FLBuilt 1966 · S/N 30-1249N317RMMonaghan Robert Edward · San Bruno, CABuilt 2008 · S/N 2084N317RVSky Blue Flyers LLC · New Holland, PAS/N 40430N317SCDuehring Jonathan H · Raleigh, NCBuilt 1968 · S/N D-8754N317SDSipila Hart A · Soquel, CAS/N 778-96N317SGGilliam Robert Lee · Tullahoma, TNS/N CD-261N317STStewart Scott R · Cloverdale, CAFirst renewal noticeBuilt 2014 · S/N 0092N317TMascelli John S · Hawthorne, CABuilt 1960 · S/N CD-95N317TRRcs Aeronautical Inc · San Antonio, TXBuilt 1973 · S/N 310Q0787N317TWYale Companies LLC DBA · Indianapolis, INBuilt 2023 · S/N 28020141N317XBogner Matthew L · Santa Cruz, CABuilt 1975 · S/N 6127CN317ZNew William C · Hemet, CABuilt 1960 · S/N D-6540N318Liberty University School Of Aeronautics · Lynchburg, VAFirst renewal noticeBuilt 1966 · S/N R172-0006N3180DKleimer Steve · Bozeman, MTBuilt 1955 · S/N 31978N3180GEdwards Thomas E · Brighton, COS/N 25002CN3180QA & L Aircraft Holding LLC · Miami Springs, FLBuilt 1967 · S/N 18258180N3180RThomas Lance E Trustee · Mesa, AZBuilt 1967 · S/N 18258580N3180UBasan Oasis LLC · Santa Teresa, NMBuilt 1963 · S/N 18254580N3180WPepe Charles · Morrisville, VTBuilt 1974 · S/N D-9574N3180YWalker Jim · Lovell, WYBuilt 1962 · S/N 18254180N3181CFour Boys Aviation LLC · Madison, MSFirst renewal noticeBuilt 1954 · S/N 30980N3181QSpitzer Helicopter LLC · Woodland Hills, CABuilt 2006 · S/N 11528
Back to AD 2007-04-19 R1