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.

N2919ZPankonin Steve B · White City, ORS/N 22-6889N291ABSerafini Louis · Ringwood, NJBuilt 1970 · S/N D-9119N291ACBennett Mark A · Normangee, TXBuilt 2000 · S/N 1285-99N291BPJackson Jeffrey L · Manchester, TNBuilt 1966 · S/N TC-979N291CAMaya Air Services LLC · Lee, NHBuilt 2004 · S/N 1373-2004N291CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 2881007N291CMAutorific High Performance Carwash Inc · Roxboro, NCBuilt 2007 · S/N TH-2195N291DCT G Dunn Plumbing Inc · Hulls Cove, MEBuilt 1953 · S/N 30110N291DMMiller Jerry L · Garrison, NDBuilt 1999 · S/N 405-99N291DSPetko James G · Mishawaka, INS/N 001N291ECElizabeth City State University · Elizabeth City, NCBuilt 2021 · S/N 172S12646N291FWilliams Joshua B · Reno, NVS/N 22153N291FCKellner Kenneth J · Neenah, WIBuilt 1999 · S/N CHENEVERT 0001N291GTNattjat Aviation LLC · El Dorado Hills, CABuilt 2001 · S/N 2091N291HAChandler Air Service Inc · Chandler, AZBuilt 1966 · S/N 28-22138N291HPBurke Matthew Joel · Maricopa, AZBuilt 2003 · S/N 2843578N291HWMiddle Village Enterprises LLC · Maspeth, NYBuilt 2012 · S/N 172S11239N291JBSoules William P · Las Cruces, NMBuilt 1995 · S/N 20412N291JDDahapov LLC · Boca Raton, FLBuilt 2012 · S/N 18282322N291KFTotal Flight Aircraft Leasing LLC · Apex, NCBuilt 1972 · S/N 17260482N291LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2021 · S/N 28020013N291LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881168N291MCGonzalez Joseph III · Saginaw, TXBuilt 1972 · S/N 28R-7335026N291MEUnique Educational Experiences · Long Beach, CABuilt 2000 · S/N 172S8550N291MGGeorgia Aviation Authority · Eastman, GABuilt 2014 · S/N 2843773N291MKPlane Nonsense Inc · Middletown, DEBuilt 2000 · S/N 2842086N291PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2022 · S/N 172S12865N291PSInternational Air Services Inc Trustee · Carson City, NVBuilt 1995 · S/N 5322N291RAParsons Aviation Inc · Wilmington, DEBuilt 2003 · S/N 445-2003N291RBAbbott Air Inc · Hydro, OKBuilt 1982 · S/N 414A0836N291RPGtr Aero LLC · Moultonborough, NHBuilt 1981 · S/N 17274327N291RVWarped Spoon LLC · Kalispell, MTBuilt 2008 · S/N 40291N291SAWoods Aviation LLC · Kearney, NEBuilt 2005 · S/N 982-2005N291SGMiller John J · Fairfax, VABuilt 1990 · S/N 1032N291SPBarr Air Patrol LLC · Mesquite, TXBuilt 1986 · S/N 18268546N291TPSparebanc LLC · Appleton, MNS/N 889-2001N291WCColorado Mesa University · Grand Junction, COBuilt 2022 · S/N 28020052N29204Jms Aviation LLC · Waynesville, OHS/N U206-1162N29209Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 21059832N2920GStevenson Taylor A · Dallas, TXBuilt 1980 · S/N 340A0115N2920KBowen Kenneth W · Bainbridge Island, WABuilt 1979 · S/N 18053130N2920PErwin Randall · Johnson City, TNBuilt 1955 · S/N 22-3188N2920RCarboneau Luke · Las Cruces, NMBuilt 1962 · S/N 310G0120N2920WBrown Jeffrey C · Bozeman, MTBuilt 1965 · S/N 28-2435N2920YApplegate Susan P · Decatur, TXBuilt 1962 · S/N 18253920N2920ZBruch Robert Allen · Roanoke, VABuilt 1959 · S/N 22-6890N29210Hawkes Brian R · Hamilton, MTBuilt 1968 · S/N U206-1165N29215Lzl Aviation LLC · Wilmington, DEBuilt 1979 · S/N 28-7916420N29217Dawson Adam J · Eveleth, MNBuilt 1968 · S/N U206-1171N29218Israelsen Martin · Santa Rosa Beach, FLBuilt 1979 · S/N 28-7916422
Back to AD 2007-04-19 R1