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.

N3814VCert Works LLC · Bennett, COBuilt 1977 · S/N R1722264N3814WN3814w LLC · Maumee, OHBuilt 1966 · S/N 32-745N3814YLadner Donald E · Centerville, TXS/N 21058314N3815DAlaska Homested Lodge Inc · Soldotna, AKBuilt 1957 · S/N 34515N3815EHonest Dog Farms LLC · Fayetteville, GABuilt 1966 · S/N 30-1335N3815FOrr Charles W III · San Ramon, CABuilt 1977 · S/N 0783N3815KShoemaker James W · Hilltop Lakes, TXBuilt 1980 · S/N CE-939N3815PNorth Louisiana Aviation LLC · Mer Rouge, LABuilt 1981 · S/N E-1850N3815WCk Aviation LLC · Milledgeville, GABuilt 1966 · S/N 32-746N3815YBorean Anthony J · Olathe, COBuilt 1964 · S/N 21058315N38166S&P Airplane Sales · Branson West, MOBuilt 1981 · S/N TC-2371N38168Jjj&S Aviation Corp · Brooklyn, NYBuilt 1981 · S/N E-1808N3816FHotzel Jeffrey F · Gladstone, MOBuilt 1977 · S/N 0784N3816PJohnson Dale M · Seminole, TXBuilt 1955 · S/N 22-3506N3816QGoli Aviation LLC · Raleigh, NCBuilt 1971 · S/N 17259916N3816SKey Field Flyers LLC · Toomsuba, MSBuilt 1981 · S/N E-1806N3816T1 Vision General Aviation LLC · Sioux City, IABuilt 1967 · S/N 28R-30132N3816YDegregorio Dennis P · Tinley Park, ILBuilt 1981 · S/N M-2304N3816ZBouchard Timothy D · Valdez, AKBuilt 1961 · S/N 18-7554N38175Fhg Springbrook Corp · Wilmington, DEBuilt 1981 · S/N CE-940N38177Archer Enterprises Corp · Ossining, NYBuilt 1977 · S/N 28-7790526N38178Gcs Aero LLC · Laramie, WYBuilt 1977 · S/N 28-7790527N3817DOff The Step Inc · Creswell, ORBuilt 1957 · S/N 34517N3817MGulf Skies LLC · Kalispell, MTBuilt 1981 · S/N EA-191N3817PCoslor Donald D Jr · Grand Island, NEBuilt 1955 · S/N 22-3507N3817QMoses Aviation Services LLC · Uvalde, TXS/N 17259917N3817XPeterson Randall J · Lake Havasu City, AZBuilt 1966 · S/N 310K0217N3817ZLivermont Joann M · Dillingham, AKS/N 18-7555N38180Raymond Katherine · Akron, OHBuilt 1981 · S/N 18267880N3818QRanch Hand Flying Club Inc · Gardiner, NYBuilt 1972 · S/N 17259918N3818TMccawley Gerald J · Parksley, VABuilt 1967 · S/N 28R-30134N3818WHeadwinds Maintenance Inc · Fort Pierce, FLBuilt 1966 · S/N 32-750N3818XAcme Racing LLC · Overland Park, KSBuilt 1966 · S/N 310K0218N38190Classic Aviation Inc · Pella, IABuilt 1977 · S/N 28-7725260N38191Burgess Sheldon A · Raymond, MSBuilt 1981 · S/N M-2303N38193Ramirez Katherin · Homestead, FLBuilt 1977 · S/N 28-7725265N38195Inspiration Aviation Ministries · Waterville, MEBuilt 1977 · S/N 28-7716230N38197Anderson Loran · Cooperstown, NDBuilt 1977 · S/N 28-7716231N38198Zero Mike LLC · Chattanooga, TNBuilt 1981 · S/N TC-2387N3819FBuntings Grassroots Aviation LLC · Selbyville, DEFirst renewal noticeS/N 0787N3819PLucas Lester L · Napa, CAS/N 22-3509N3819QGulf Coast Aero Club Inc · Sarasota, FLBuilt 1971 · S/N 17259919N3819TChism Alicia L · Lawrence, KSBuilt 1967 · S/N 28R-30136N3819XBoerne Flight Options LLC · Boerne, TXBuilt 1966 · S/N 310K0219N3819YLaycock Justin D · Johnson City, TNBuilt 1964 · S/N 21058319N381ACKarter Transport Enterprise LLC · Monterey, CABuilt 2007 · S/N E-3759N381BTPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010085N381CAOltman Neil R · Sandia Park, NMBuilt 2004 · S/N 1368-2004N381CC182 Flight Corp · Bronx, NYBuilt 2001 · S/N 9936CCN381CDN381cd Aviation LLC · Ventura, CABuilt 2005 · S/N 1432
Back to AD 2007-04-19 R1