OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,428

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.

N14PGorman Aviation LLC · Bartlesville, OKBuilt 1985 · S/N TJ-492N14PE14pe LLC · Omaha, NEBuilt 2002 · S/N 3309N14PHHuman Lee · Mercer Island, WABuilt 1981 · S/N 18504323N14PJHoule Daniel G · Ely, MNBuilt 1984 · S/N 245N14PLByers Steven · San Diego, CABuilt 1966 · S/N 18051711N14PSDodson International Parts Inc · Rantoul, KSBuilt 1996 · S/N 7EF-25N14PTSchmeeckle Zane · Fort Morgan, COBuilt 2007 · S/N 001N14PVRogers Michael P · Neenah, WIBuilt 2003 · S/N 172S9528N14QAAlba Leasing Services LLC · Scottsdale, AZBuilt 2006 · S/N 11370N14QWDinucci Mario · Auburn, CABuilt 2006 · S/N 18281760N14REIngold Terry L · Albemarle, NCBuilt 1983 · S/N EICHER 0001N14RFBerry Darrel · Camden, TNBuilt 1973 · S/N E-486N14RGGrice Robert H · Irvington, ALBuilt 1980 · S/N 628N14RVEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1979 · S/N 1N14RWJohnston Jeffrey T · Ramsey, MNS/N 28-10217N14SASidney Aviation LLC · Sidney, NEBuilt 2014 · S/N 1146-2014N14SEBlake Rodney D · Trophy Club, TXBuilt 2009 · S/N 70362N14SPAmyateef Lllc · North Las Vegas, NVBuilt 1978 · S/N 61P-0494-202N14SVBaron Robert David · Rochester, MIBuilt 1947 · S/N 537N14TWAllbid Inc · Opelousas, LAS/N 670148N14VCG5 LLC · Gallup, NMS/N 18264127N14VFKingery Michael E · Evergreen, COBuilt 2020 · S/N 70508N14VMKaindl Robert · Redmond, WAS/N 61P-0319-088N14WBeyer Mark E · Towanda, KSBuilt 1993 · S/N 11132N14WFSamberg Scott S · Gillette, WYBuilt 1976 · S/N 233-76N14WGWest Coast Equipment Leasing LLC · Aurora, ORFirst renewal noticeBuilt 2019 · S/N 172S12415N14WJSchifini Warren B · Dairy, ORS/N 2817N14XMMedical Diagnostic Imaging Inc · Sacramento, CABuilt 1976 · S/N TH-758N14YBKate Air LLC · Southlake, TXBuilt 1979 · S/N 28-7990461N14YHScofield Ryan · Greeley, COBuilt 2004 · S/N 071N14YLHarker James P · Blaine, MNBuilt 1945 · S/N 5-3005N14YUInternational Air Services Inc Trustee · Carson City, NVBuilt 1992 · S/N 10135N14YYNorthwoods Air LLC · Orono, MEBuilt 1972 · S/N 18261390N15000Central District Aviation LLC · Seattle, WABuilt 1969 · S/N 17258075N15002Registered aircraftBuilt 1972 · S/N 28-7205315N15003Flying Untethered LLC · Saranac Lake, NYBuilt 1972 · S/N 28-7225548N15005Oliver Everett G · No Mankato, MNBuilt 1972 · S/N 28-7205316N15006Corio Salvatore J Jr · Warwick, RIBuilt 1972 · S/N 28R-7235315N15007Marshall County Flying Club Inc · Lacon, ILBuilt 1972 · S/N 28R-7235316N1500BElectrical Field Services Inc · Huffman, TXBuilt 1994 · S/N CE-1768N1500FGerhold Jeremy · Rosharon, TXS/N D-8552N1500G5 Lg LLC · Rome, GABuilt 1975 · S/N 414-0814N1500SCianchette R Scott · Hermon, MEBuilt 1961 · S/N D-6897N1500VTessem Rolfe S · Great Barrington, MABuilt 1970 · S/N D-9160N15010Van Buskirk James R · Tuttle, OKS/N 28-7225550N15018N15018 LLC · Sanger, TXBuilt 1972 · S/N 34-7250347N1501CUnderwriting Wave LLC · Woodland Hills, UTBuilt 2003 · S/N 0528N1501MMeszler Christopher P · Spring Branch, TXBuilt 1975 · S/N 18264354N1501STaylor Counsel LLC · Hoschton, GABuilt 1962 · S/N D-6898N1501XBowser William K · Ball Ground, GABuilt 1975 · S/N 28-7505235
Back to AD 2007-04-19 R1