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.

N2786GAvery John W · Fergus Falls, MNFirst renewal noticeBuilt 1959 · S/N 52086N2786XRegistered aircraftBuilt 1965 · S/N 18051586N2787AKnudson Erik · Chandler, AZBuilt 1969 · S/N E-178N2787FWammen Gil V · Reva, SDBuilt 1966 · S/N 18256887N2787GGomez Bermudex Investments LLC · Lauderhill, FLS/N 52087N2787JLarson Jared E · Wasilla, AKBuilt 1969 · S/N 185-1537N2787KWhirlwind Aviation Inc · Fisher, ARBuilt 1979 · S/N 18053068N2787QThorell Farms Inc · Loomis, NES/N 18257987N2787TBombero Aviation LLC · Childress, TXBuilt 1967 · S/N TE-388N2787WWhite Gary L · Ashland, KSBuilt 1966 · S/N 1067N2788Tippit Larry Jack · Grand Prairie, TXFirst renewal noticeBuilt 1970 · S/N 30PN2788FShryock Patrick D · King Salmon, AKS/N 18256888N2788GCaldwell Gregg P · Desert Hot Springs, CABuilt 1959 · S/N 52088N2788QKahle Matthew N · Paw Paw, MIBuilt 1967 · S/N 18257988N2788THarnden Craig A · Lake City, FLBuilt 1967 · S/N CE-154N2789FHouck Joshua B · Wa Ct House, OHS/N 18256889N2789QCenterline LLC · Yankton, SDBuilt 1967 · S/N 18257989N2789TLaycock Sean P · Plymouth, MIBuilt 1967 · S/N D-8483N2789WShort Robert N II · Lincoln, CABuilt 1966 · S/N 1169N278AMokulele Research Corp · Honolulu, HIBuilt 2007 · S/N 70224N278AGEpic Aviation Inc · New Smyrna Beach, FLBuilt 2020 · S/N 4496506N278CA278ca LLC · Union Gap, WABuilt 2008 · S/N 172S10801N278CCUS Department Of The Interior · Boise, IDBuilt 2012 · S/N CC18-0057N278CDCirrus Aviators LLC · Elm Grove, WIBuilt 2002 · S/N 0337N278CFInfinity Aviation LLC · Mandan, NDBuilt 1981 · S/N 18504228N278CMVarakantham Indra Sena Reddy · Allen, TXBuilt 2004 · S/N 40.391N278CRRittgers Timothy · Lapeer, MIBuilt 1986 · S/N CE-1089N278DBCt42 LLC · New York, NYS/N 29-0301N278DSRelm Air LLC · Wilmington, DEBuilt 2003 · S/N 40.278N278FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13453N278FKKoelbl Aviation LLC · Whitesboro, TXBuilt 2003 · S/N 3417N278GTankersley Aviation LLC · Sylacauga, ALBuilt 1979 · S/N E-1547N278HBEastman Douglas F · Eastlake, COBuilt 1982 · S/N 278N278HJJohnson Joel P · Duluth, MNBuilt 1967 · S/N 185-1268N278JGThompson Barrett R · Smyrna, TNBuilt 1998 · S/N JS-001N278KERotor Technologies Inc · Nashua, NHBuilt 2006 · S/N 11178N278MReid Stephen M · Gardner, KSBuilt 1980 · S/N TH-1105N278MGGeorgia Aviation Authority · Eastman, GABuilt 2018 · S/N 2881019N278MHSimms Hospitality Group LLC · El Segundo, CABuilt 2022 · S/N 3400N278NDRegistered aircraftBuilt 2002 · S/N 2844069N278PBP21000318 Inc Trustee · Wilmington, DEBuilt 1979 · S/N P21000318N278RHolliday Henry S · Poplarville, MSS/N E-1181N278SHSmith Kenneth S Jr · Uvalde, TXBuilt 2007 · S/N 4224N278SJOrr George Douglas · Hood River, ORBuilt 2000 · S/N 113N278SPSvetful Aviation LLC · Camden, SCBuilt 2003 · S/N 172S9474N278ZKennerson Robert L · Palmer, AKBuilt 1981 · S/N 18-8109030N2790GBryan Roger J · Spearfish, SDBuilt 1959 · S/N 52090N2790QArthur Lloyd T · Greenfield, INS/N 18257990N2790WMoondogger LLC · Yakima, WAS/N 1068N27918Reneau Thomas E · Midland, TXBuilt 2001 · S/N 2974
Back to AD 2007-04-19 R1