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.

N3144YSierra Bravo Zulu LLC · Middletown, DES/N E-2437N3144ZWasilowski Richard P · Arlington, WABuilt 1959 · S/N 22-7089N31453Kuhlig Clemens C · Hobe Sound, FLBuilt 1979 · S/N 2189N31456Flying Time LLC · Jenks, OKBuilt 1979 · S/N 2190N3145MWright Jeffrey Crandel · Opelika, ALBuilt 1992 · S/N L001N3145QN3145q LLC · Cave Creek, AZBuilt 1967 · S/N 18258145N3145RSchnell Tyler C · Spearman, TXBuilt 1967 · S/N 18258545N3145SCorriher Ronald R · Mount Ulla, NCBuilt 1964 · S/N 18255645N3145WIfly Aviation LLC · Conway, ARBuilt 1973 · S/N E-505N3145YSiskiyou Aviation LLC · San Jose, CABuilt 1962 · S/N 18254145N31465Stewarts Aircraft Service Inc · Waynesville, OHBuilt 1979 · S/N 2198N3146FMeyer Jackson · Soldotna, AKBuilt 1966 · S/N 18257246N3146LGarnett Robert A · Drewsey, ORBuilt 1992 · S/N 595N3146QJpw LLC · Red Lodge, MTBuilt 1967 · S/N 18258146N3146RBednarik Edward L · Morgantown, PABuilt 1967 · S/N 18258546N3146SBell Stephen Francis Trustee · Ponte Vedra, FLBuilt 2005 · S/N 40047N3146UAscend Aviation LLC · Post Falls, IDS/N 18254546N3146WWalker Ernest F · Bala Cynwyd, PABuilt 1973 · S/N CE-479N31471Hangar 21 Aviation Inc · Lake Havasu City, AZBuilt 2006 · S/N 11419N31474Nemeroff Jason R · Scappoose, ORBuilt 1979 · S/N 2205N31475Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 2207N3147CSchlutz Ivan F · Longmont, COBuilt 1954 · S/N 30946N3147LBrowning Charles H III · Woodbine, MDBuilt 1994 · S/N E-2882N3147QBernbeck Alan R · Benton, KSBuilt 1967 · S/N 18258147N3147TClinton Grant A · Portage Des Sioux, MOS/N 17700447N3147WTadesco Rothchild LLC · Wilmington, DEBuilt 1973 · S/N D-9569N3147ZNeudorf Robert H · Alamogordo, NMBuilt 1959 · S/N 22-7094N31482First Flight Aero LLC · Reno, NVBuilt 1980 · S/N 2218N31485Unusual Attitudes LLC · Bates City, MOBuilt 2006 · S/N 4088N3148CFreund Timothy P · Mesa, AZBuilt 1954 · S/N 30947N3148PSky Hi Aviation LLC · Wilmington, DEBuilt 1977 · S/N 210-61945N3148RMyl High Flying Club LLC · Mccall, IDBuilt 1967 · S/N 18258548N3148SHauser Family Flying LLC · Mount Pleasant, PABuilt 1964 · S/N 18255648N3148TMiller John W · Bluffton, INBuilt 1967 · S/N 17700448N3148YHernandez Alfonso C · Garland, TXBuilt 1962 · S/N 18254148N31494Locker Aircraft Inc · Muleshoe, TXBuilt 1988 · S/N CE-1269N31497N400sr LLC · Astoria, NYBuilt 1988 · S/N CE-1275N3149LChopper 4 LLC · Dover, DEBuilt 2006 · S/N 11426N3149QClear Air LLC · Ashford, CTBuilt 1977 · S/N 28-7790439N3149TShugart Fredrick William · Canfield, OHBuilt 1967 · S/N 17700449N314AKTremble Toby K · Wasilla, AKBuilt 2024 · S/N 1001N314AVN1412v LLC · Manassas, VABuilt 1974 · S/N 17263557N314BAComer Jacob · Troy, MOBuilt 1962 · S/N 18254547N314DBButler David Trustee · Palos Park, ILBuilt 2004 · S/N 921N314DGLaminar Holdings LLC · Sheridan, WYBuilt 2007 · S/N 260N314DSFlyers Unlimited LLC · Tucson, AZBuilt 2005 · S/N 1705N314EPHeadings Andrew R · Blue River, WIBuilt 1998 · S/N 24378N314FRHawkeye Helicopter LLC · Lyndon, KSBuilt 1998 · S/N 18280260N314GTYellow Jacket Flying Club Inc · Atlanta, GABuilt 1981 · S/N 17274774N314HBMarc Inc · Bolton, MSBuilt 1979 · S/N 310R1586
Back to AD 2007-04-19 R1