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.

N4158BCapristo Construction · Cape Coral, FLS/N 76-30801N4158DBoho LLC · Lewes, DEBuilt 1994 · S/N 1809087N4158LJm Lavore Aero Inc · Lakeside, MTBuilt 1994 · S/N 1809100N4158WButler John P · Hazelhurst, WIBuilt 1994 · S/N 1809102N4158YAlliance Aircraft Sales Inc · Pierre, SDBuilt 1994 · S/N 1809103N4158ZSchaetzel Paul Robert · New Meadows, IDBuilt 1965 · S/N 18-8340N41593Flyin LLC · Hyde Park, UTS/N 28-7415286N41594Butler John P · Hazelhurst, WIBuilt 1994 · S/N 1809113N41598Fox Flying Club Inc · Wheaton, ILBuilt 1999 · S/N 2843290N41599Tiger Helicopters LLC · Baton Rouge, LABuilt 1999 · S/N 4636187N4159AHauser Associates Inc · Coral Gables, FLBuilt 1994 · S/N 1809106N4159DBachman Aviation LLC · Independence, IAS/N 1809110N4159KRegistered aircraftBuilt 1998 · S/N 22015CN4159PSparks Brian E · Monmouth, ORBuilt 1959 · S/N 23-1644N4159SCrew Marshall D · Spokane, WABuilt 1994 · S/N 1809109N4159TGholami Amir H · Santa Rosa, CABuilt 1965 · S/N 320D0059N4159XHagglund Carl D · Pendleton, ORS/N 341N4159YBauer Aviation LLC · Reese, MIBuilt 1977 · S/N 23877N415AMUtah State University · Logan, UTBuilt 2005 · S/N 40.517N415BHCentral Airlines Inc · Overland Park, KSBuilt 1960 · S/N 500B-918-5N415CAFly For Fun Aircraft LLC · Baltimore, MDS/N 2843215N415CCCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1968 · S/N 27-3908N415CFAlo Fliteline Lc · Waterloo, IABuilt 1975 · S/N 28-7505118N415DHSparks Group Inc · Jay, OKBuilt 1957 · S/N D-4916N415ECCreativity Before Capital LLC · Tampa, FLBuilt 2006 · S/N 40415N415GB415gb LLC · Encinitas, CABuilt 2000 · S/N E-3363N415GEN415ge LLC · Wilmington, DES/N 0693N415GFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2001 · S/N 0067N415GKCentral Clinton County Flying Club Inc · Jersey Shore, PABuilt 1982 · S/N 28-8290151N415GSKirkman Robert Nolan · Pilot Mountain, NCBuilt 2004 · S/N 81406N415HPRichmond George H Jr · Elkhorn, NEBuilt 1963 · S/N 30-181N415JBBrewer Allen E · Madison, MSBuilt 1999 · S/N 1463N415JLOlson Douglas W · Yarmouth Port, MABuilt 1981 · S/N E-1801N415JSCarey James A · St Charles, ILBuilt 2016 · S/N 40874N415KGSky Safety Inc · San Antonio, TXBuilt 2005 · S/N 40.483N415LLost Pines Tours LLC · Bastrop, TXBuilt 1977 · S/N 32-7740073N415LEStadelman Edwin F · East Falmouth, MABuilt 1999 · S/N 20608042N415MEngelien Wendell · Port Orange, FLBuilt 2025 · S/N 24456N415MDHammychan Industries LLC · Glendale, AZBuilt 1967 · S/N 27-3492N415MRKropp Matthew M · North Creek, NYBuilt 2014 · S/N 001N415MSNextgen Flight Academy Inc · Riverside, CABuilt 1978 · S/N 28-7816430N415PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843448N415PJPalm Springs Air Museum · Palm Springs, CAS/N 0002N415RGalyon Aviation LLC · Sweetwater, TNBuilt 1958 · S/N TD-161N415RABoas Mark S · Hollywood, MDBuilt 1975 · S/N 421B0874N415RCAvco Patrol LLC · Lyndon, KSBuilt 1998 · S/N 18280302N415RJAviation Training LLC · Wilmington, DEBuilt 2005 · S/N 172S9943N415RPRotorpro LLC · Sevierville, TNBuilt 2004 · S/N 10474N415RWSale Reported · Jasper, ALSale reported, pending cancellationBuilt 1968 · S/N TE-643N415SGriffing Flying Service Inc · Port Clinton, OHBuilt 1978 · S/N 28-7990041
Back to AD 2007-04-19 R1