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.

N55386Redlands Flying Club · Redlands, CAS/N 1189N5538ARado Robert L · Petersburg, MIBuilt 1952 · S/N 20-944N5538KHilowitz Andrew J · Anchorage, AKBuilt 1978 · S/N 1045-78N5538QDurkee Brenton J · Brooklyn, NYBuilt 1965 · S/N 622N5538UAircraft Sales LLC · Caledonia, MIBuilt 1969 · S/N 28-26260N5538XBeartooth Air LLC · Cody, WYBuilt 1989 · S/N CE-1373N5538YTeton View Aircraft Leasing LLC · Grass Valley, CABuilt 1981 · S/N 21064241N55390Davis Hunter · Winters, TXBuilt 1973 · S/N 28-7310134N55392Fast Aircraft Aerowork Corp · Fort Lauderdale, FLNon-citizen corporation, flight hours not reportedBuilt 1973 · S/N 28-7325391N55397Stephens Ryan L · Gardner, ILBuilt 1973 · S/N 28-7305374N55398Three Wire LLC · Portland, ORBuilt 1981 · S/N 17275174N5539ASchneider Benjamin J · Wheeling, WVS/N 20-945N5539FAeronautical Technical Service Inc · Collierville, TNBuilt 1968 · S/N 28-24938N5539JCarr Paul · Ottumwa, IAS/N 32-1000N5539QJostad Leo D · Bottineau, NDBuilt 1965 · S/N 2958N5539SLm Air Patrol Service Inc · Wink, TXBuilt 1966 · S/N 188-0039N5539TPattison Aero Inc · Henderson, NVS/N R18201889N5539UDickey Blaine K · Marion, ARBuilt 1969 · S/N 28-26261N553APAviation Paradise LLC · Homestead, FLBuilt 1980 · S/N 17274554N553BBJpm Flying Service LLC · Marine, ILBuilt 2017 · S/N 2014N553BCCarlson Robert A · Red Wing, MNBuilt 2001 · S/N 2171N553CDMhz Management LLC · Wilmington, DEBuilt 2005 · S/N 1638N553DCCain T&T LLC · Kalispell, MTBuilt 2006 · S/N 27014CN553DLRegistration Pending · Manchester, TNRegistration pendingBuilt 2008 · S/N 12467N553FLWalters Rande L Sr · Lock Haven, PABuilt 1971 · S/N 28-7125392N553JBHelicopter Institute Inc · Fort Worth, TXBuilt 2010 · S/N 13071N553KMRieder Kenneth J · Cincinnati, OHBuilt 2004 · S/N 81553N553LPMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1978 · S/N 414A0092N553MBBickling Melvin T · Johnstown, COBuilt 2011 · S/N 91457N553PCSaint Louis University · St Louis, MOBuilt 2001 · S/N 4496072N553PGAnderson Adam Z · Bay City, MIBuilt 2005 · S/N 2318N553PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842090N553RARich Aviation Services LLC · Fort Worth, TXBuilt 2012 · S/N 172S11176N553RVLittmann Daniel M · Broken Arrow, OKBuilt 2018 · S/N 74536N553SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881342N553SFSmith Nancy R · Duluth, MNBuilt 1966 · S/N 247N553SWHeritage Air LLC · Grove, OKBuilt 1981 · S/N 414A0614N553TAIctus Specialized Power Products Inc · Houston, TXS/N 18258199N553TPOakland Flyers LLC · Oakland, CABuilt 1975 · S/N 28-7690105N553WP6sm Aviation LLC · Savannah, GABuilt 1974 · S/N TC-1757N554Valiair Lc Trustee · Casper, WYS/N 1232N55401Keesling Roger · Starkville, MSBuilt 1973 · S/N 28-7325405N55402Gleason Scot · Hayden, IDBuilt 1973 · S/N 28-7325395N55404Atlanta Aviation Academy Inc · Lawrenceville, GABuilt 1981 · S/N 17275175N55407Yeager Bradley William · New Market, ALBuilt 1973 · S/N 28-7305377N5540JLesser Antilles Corp Trustee · Wilmington, DEBuilt 1968 · S/N 32-1003N5540KTymczyszyn William R · Torrance, CABuilt 1978 · S/N 394-78N5540UEvans Thomas Patrick · Hollow Rock, TNBuilt 1969 · S/N 28-26262N5540WAir-Crete Constructions Inc · Lake Elmo, MNBuilt 1962 · S/N 28-631N55414Macair Aviation LLC · Xenia, OHBuilt 1973 · S/N 34-7350212
Back to AD 2007-04-19 R1