OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,433

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.

N2190TGonzales Rene V · Lampasas, TXBuilt 1971 · S/N 28-7205029N21914Autumn Air LLC · Prescott, AZBuilt 1977 · S/N D-10078N2191EBel Air Aviation LLC · Chesaning, MIFirst renewal noticeBuilt 1978 · S/N 28-7990179N2191FOhlinger Michael B · Mission, TXBuilt 1965 · S/N U206-0391N2191JOefelein William A · Wasilla, AKBuilt 1960 · S/N 18-7185N2191LAir Leasing Service Inc · Hillsborough, NJS/N 28R-7918031N2191R2gl P&I LLC · El Paso, TXS/N 18255391N2191UJohnson Kenneth E · Mahtomedi, MNBuilt 1964 · S/N 402N2191WNorton Daniel J · Osage City, KSBuilt 1974 · S/N MB-727N21921Rosato Kevin Scott · Cullowhee, NCBuilt 1979 · S/N 61P-07147963345N2192GWood Kyle A · Soldotna, AKBuilt 1958 · S/N 51492N2192JMcguire Robert · Hawthorne, FLBuilt 1999 · S/N 29-0206N2192NArnold Mark Douglas · Holloway, MNBuilt 1999 · S/N 30-0041N2192PSandoval Tax Cpas Inc · Bakersfield, CABuilt 2005 · S/N 18281668N2192TMazza Frank · Bridgeton, NJBuilt 1971 · S/N 28-7205043N2192WRegistered aircraftS/N 22-2605N2192ZTalbott Erin W · Palouse, WAS/N 18051292N2193PDeem Adam C · Norton, OHBuilt 1990 · S/N 1795N2193RBig Island Gravity LLC · Kapaau, HIBuilt 1964 · S/N 18255393N2193VApm Leasing LLC · Casper, WYBuilt 1979 · S/N 44-7995266N2193WAzalea Utilities Inc · Summerville, SCBuilt 2005 · S/N 18281670N2194GMeyer Wayne G · Bozeman, MTBuilt 1958 · S/N 51494N2194KAviation Training LLC · Wilmington, DEBuilt 1978 · S/N 44-7995203N2194LState Of Wisconsin · Madison, WIBuilt 2005 · S/N 18281672N2194RJacobson Aviation LLC · Hannibal, MOBuilt 1964 · S/N 18255394N2194TNelson Donald M Jr · Fair Oaks, CABuilt 1971 · S/N 28-7205045N21950Cousins Mark T · Portland, ORS/N 17264046N21956Lake Elmo Flyers LLC · Vadnais Heights, MNBuilt 1974 · S/N 17264048N21958Hillsboro Aero Ltd · Hillsboro, NDBuilt 1976 · S/N 18503072N2195EZameroski Daniel C · Mckean, PABuilt 1978 · S/N 28-7990182N2195FRobinson Tracy · Veneta, ORBuilt 1965 · S/N U206-0395N2195LGinsberg Andrew P · Rochester, NYBuilt 1979 · S/N 28R-7918032N2195MKorba Sean · San Jose, CABuilt 1979 · S/N 28-7911090N2195PZahlmann Daniel R · Queen Creek, AZS/N 23-803N2195RMclean Laura A · Palmer, AKS/N 18255395N21964Matt Anchordoguy Co LLC · Vina, CABuilt 2007 · S/N 18281945N2196NThompson Kurt C · Rochester, MNBuilt 1979 · S/N 32-7940037N2196RStonebrink Melvin D · Wallowa, ORBuilt 1964 · S/N 18255396N2196SHernandez Christopher A · Phoenix, AZBuilt 1968 · S/N 180753N2196TTilly Curtis L · Raleigh, NCBuilt 1971 · S/N 28-7205047N2196UZeiner Gary R · Greencastle, INBuilt 1964 · S/N 407N2196VFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1979 · S/N 44-7995267N2196ZAnderson Randy · Brantingham, NYBuilt 1963 · S/N 18051296N2197GBreshears Jason N · Cameron, MOBuilt 1958 · S/N 51497N2197HGprr Inc · Downers Grove, ILBuilt 1999 · S/N 29-0208N2197LJ Rougeau Rehab Inc · North Adams, MABuilt 1976 · S/N TC-2018N2197TAdams Donald L · Huntsville, ALBuilt 1971 · S/N 28-7205048N2197WSmothers Edward Jr · Owasso, OKBuilt 1974 · S/N MB-697N2197XKelley Brian S · Vancouver, WAS/N 23293N21985N21985 LLC · Deltona, FLBuilt 1978 · S/N 28-7990066
Back to AD 2007-04-19 R1