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.

N26323Peachtree Builders LLC · Waterford, NYS/N AA5A0534N2632BHeubeck Associates Inc · New York, NYBuilt 1979 · S/N 310R1626N2632CSheldon Benjamin Lloyd · Duck Creek Village, UTBuilt 1978 · S/N R18200184N2632FOn Final Holdings LLC · West Olive, MIBuilt 1965 · S/N 18256732N2632GHuey James M · Fulton, MOFirst renewal noticeBuilt 1959 · S/N 51932N2632JDevries Mark R · Eagle River, AKBuilt 1957 · S/N 18-5858N2632PBargabos Richard O · Peterboro, NYBuilt 1960 · S/N CD-114N2632WKrapp Transfer · Jamestown, NDBuilt 1966 · S/N 3300N2632YAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280570N26330Davis Timothy Scott · Lexington Park, MDBuilt 1978 · S/N AA5A0536N26334Mullins Donald · Pounding Mill, VAS/N AA5A0537N26337Munson Andreas C · Seattle, WABuilt 1978 · S/N AA5A0538N2633CWalusz Bernice J · Linden, NJS/N R18200185N2633FYork Greg · Blanco, TXBuilt 1965 · S/N 18256733N2633RDevries Mark R · Eagle River, AKBuilt 1967 · S/N 18258333N26349Bonnell Corey K · Waxahachie, TXBuilt 1978 · S/N AA5A0540N2634EAzul Services LLC · Bozeman, MTBuilt 1998 · S/N 17280572N2634FCockerham Milton D · Gooding, IDBuilt 1965 · S/N 18256734N2634MN2634mm LLC · Farmingdale, NYBuilt 1977 · S/N 28-7816298N2634RRichardson Michael T · Inver Grove Hghts, MNS/N 28R-35236N2634WGuerrero Aircraft LLC · Newport, WABuilt 1966 · S/N 973N26353Scoggin Gerald W III · Port Saint Lucie, FLS/N AA5A0541N2635BGrimes Jeremy M · Wasilla, AKBuilt 1959 · S/N 50390N2635CMason Gregory J · Rice Lake, WIBuilt 1978 · S/N R18200186N2635GStockton Finance Inc · New Braunfels, TXBuilt 1959 · S/N 51935N2635KVerdi Stephen · Newtown, PABuilt 1978 · S/N 18053020N2635PSchuller Henry Michael · Arlington, WABuilt 1955 · S/N 22-2973N2635QAir-Mods Flight Academy · Robbinsville, NJBuilt 1977 · S/N 28-7716115N2635RJong Hoon Cho · Rch Palos Vrd, CABuilt 1967 · S/N 18258335N2635WElam Brent R · Woodford, VABuilt 1966 · S/N 974N26360Stickney John M · Chapin, SCBuilt 1978 · S/N AA5A0543N26368Parker Dennis A · Charlevoix, MIBuilt 1978 · S/N AA5A0544N2636CSexton David Lee · Barnesville, GABuilt 1978 · S/N R18200187N2636FCernilia James J · Newport Beach, CABuilt 1965 · S/N 18256736N2636GHousken George E · Gardnerville, NVFirst renewal noticeBuilt 1959 · S/N 51936N26370Gv Air Inc · Medford, ORBuilt 1979 · S/N 310R1659N26379Wings Over Texas Holdings LLC · Denton, TXBuilt 1998 · S/N 17280573N2637CSafety In Motion Flight Center Inc · Puyallup, WABuilt 1978 · S/N R18200188N2637DMcanulla Robert · Trabuco Canyon, CABuilt 1979 · S/N 310R1655N2637FMccrum James M · Seattle, WABuilt 1965 · S/N 18256737N2637GSalisbury Jonathan T · Seabeck, WABuilt 1959 · S/N 51937N2637PMurray James A · Wasilla, AKBuilt 1955 · S/N 22-2975N2637WCox James L · Fort Worth, TXBuilt 1966 · S/N 3302N26380Downey Matthew R · Colorado Springs, COBuilt 1977 · S/N AA5A0404N26384Farley Robert W · Warwick, MABuilt 1978 · S/N AA5A0553N26385Emerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1988 · S/N 0804N26387Masco Howard N · Huntsville, ALBuilt 1978 · S/N AA5A0555N26389Wilson Billy Joe · Granite Falls, NCBuilt 1978 · S/N AA5A0556N2638CPickett Joseph C · El Paso, TXBuilt 1955 · S/N 35038N2638GEvans Steven H · Hattiesburg, MSBuilt 1959 · S/N 51938
Back to AD 2007-04-19 R1