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.

N40VXHarder Steven R Trustee · The Sea Ranch, CABuilt 1998 · S/N 5040N40VZJump Jet LLC · Fort Worth, TXBuilt 2021 · S/N 40N40WABergstedt Yvonne · Anchorage, AKBuilt 1956 · S/N 32588N40WFGrennell Brian M · Euless, TXS/N 30-971N40WNRider Rebecca L · Hyde Park, NYBuilt 1968 · S/N 17700829N40WTPritchett Thomas A · Covington, GABuilt 1953 · S/N 30324N40WYFlywerx LLC · Anchor Point, AKBuilt 2011 · S/N 3120N40XEFly Diamond Da40 N40xe LLC · Kalispell, MTBuilt 2002 · S/N 40.208N40XPRegistration Pending · Dallas, TXRegistration pendingBuilt 1976 · S/N K-040N40XSSasser F Michael · Cedar Park, TXBuilt 1978 · S/N E-1278N40YLMeggers Roger D · Baker, MTBuilt 1996 · S/N 1327N40YRHelicopter Services LLC · Cheyenne, WYBuilt 2019 · S/N 4797N410Pacific Islands Aviation LLC · Wilmington, DEBuilt 2010 · S/N 73272N4100FGoldberg Mark · Massapequa Park, NYBuilt 1976 · S/N 28-7715006N4100PValley Flying LLC · Stuarts Draft, VABuilt 1959 · S/N 23-1580N4100YLofton Charles T · Georgetown, MNBuilt 1976 · S/N 944-76N4100ZMountain Escape LLC · Pullman, WAS/N 18-8114N4101JRichardson Howell · Gilbert, AZBuilt 1966 · S/N 28-22413N4101PKnepp Terry Wayne · Montgomery, INBuilt 1977 · S/N E-1026N4101YBower Gary R · Miranda, SDBuilt 1976 · S/N 230-76N4102BLamay James R · Reno, NVBuilt 1977 · S/N 77-31136N4102HForeman Guy W · Valparaiso, INBuilt 1978 · S/N 240617N4102LWiplinger Robert D · Inver Grove Height, MNBuilt 1973 · S/N U20602093N4102PDoran Jeffrey T · Westerville, OHBuilt 1959 · S/N 23-1582N4102SFlying Drahthaar LLC · Billings, MTBuilt 1975 · S/N TE-1038N4103NKarpik Joseph Paul · Floodwood, MNS/N 680074N4103PLumley John J · Delray Beach, FLBuilt 1959 · S/N 23-1583N4103SSky High Aviation LLC · Fishers, INBuilt 1975 · S/N TE-1039N4104PSpooter Air II LLC · Willis, TXBuilt 1959 · S/N 23-1584N4104SSky West Aviation Inc Trustee · Albuquerque, NMS/N CE-558N4104T4a Legacy Enterprises LLC · Mcallen, TXBuilt 2001 · S/N E-3411N4104XBandy Carla Sr · Texarkana, TXBuilt 1968 · S/N 201N4104YBurgett Gary · Galena, AKBuilt 1976 · S/N 945-76N4104ZZelina William B III · Fort Greely, AKBuilt 1964 · S/N 18-8124N4105CJohnson Rodney R · Roseburg, ORS/N R18200322N4105HBonanza Valley Air LLC · Alexandria, MNBuilt 1978 · S/N 24-0621N4105SAxis Aviation Group Inc · Sacramento, CABuilt 1975 · S/N TC-1845N4105YChock Steven Y H · Lopez Island, WABuilt 1962 · S/N 1850305N4105ZMccaughey Steven A · Winter Haven, FLBuilt 1964 · S/N 18-8126N4106CAir Data Solutions LLC · Natchitoches, LABuilt 1978 · S/N R18200323N4106JFlander Donald D · What Cheer, IABuilt 1966 · S/N 28-22419N4106NGioia Matthew M · Stafford, VABuilt 1968 · S/N 680035N4106SCompnet Solutions Inc · Dallas, TXBuilt 1975 · S/N CE-559N4106XRossiter Andrew J · Vancouver, WAS/N 203N4106ZJohnson Royce D · Clinton, ARBuilt 1964 · S/N 188127N4107NWest Main Auto Sales Inc · Tupelo, MSS/N 680075N4107PTm Aero Marine Inc · North Miami, FLBuilt 1959 · S/N 23-1562N4107SAnnamar LLC · Wilmington, DEBuilt 1975 · S/N D-9735N4107XRedsun Oren Daniel · Fairfield, CAS/N 205N4107YJohnson Eric L Trustee · Valley, WABuilt 1962 · S/N 185-0307
Back to AD 2007-04-19 R1