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.

N266ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496104N266BBetki Randy A · Grosse Ile, MIBuilt 1958 · S/N 126N266BBJk Air LLC · Duncan, OKBuilt 1999 · S/N T20608082N266BNPinckney Michael M DBA · Pensacola, FLBuilt 1988 · S/N 89-301001N266DHurricane Mesa Aviation LLC · Hurricane, UTS/N 13017N266DLCampbell Thomas J · Center, TXBuilt 2002 · S/N 25154N266FAStratus Rr LLC · New Castle, DEBuilt 2026 · S/N 28020262N266GSchroeder Robert J · Kaukauna, WIBuilt 1966 · S/N TE-205N266HRegistered aircraftBuilt 2008 · S/N E-3877N266JDJ D Deboskey Inc · Palm Beach Gardens, FLS/N G-810N266LARaintree Aviation LLC · Mesa, AZBuilt 2012 · S/N 172S11178N266LCCambridge Aviation LLC · Hillsborough, NJBuilt 1966 · S/N 30-1157N266MEGershman Randy · Marshfield, WIBuilt 2000 · S/N 18280772N266MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881364N266PDLiberty Garden Center Inc · Norwich, NYBuilt 1967 · S/N D-8654N266SFEastern Stearman Inc Trustee · Leesburg, VABuilt 1969 · S/N 2-29N266SHDirty Bird Helicopters LLC · Boerne, TXBuilt 2007 · S/N 4230N266SPTfs Air LLC · Loveland, COBuilt 2003 · S/N 172S9471N266SWWeddle Scott M Trustee · Albany, ORBuilt 2003 · S/N 70266N266TCAir Control Systems · Bigfork, MTS/N EA-483N266WBBell W Douglas · Grand Haven, MIBuilt 2004 · S/N 80889N266WYReps R1 Drive Unit Co LLC · Helena, MTBuilt 2016 · S/N 3266N266YHogg James R · New Albany, OHBuilt 1968 · S/N 18PN26708Flying Chester Cheetah LLC · Valdosta, GABuilt 1978 · S/N AA5A0665N2670MPhelan Construction LLC · North Andover, MABuilt 1986 · S/N CE-1082N2670YErickson Wesley B · Littleton, COBuilt 1962 · S/N 18051170N26713N26713 LLC · Gainesville, GAS/N AA5A0668N26715Gulfstream Aerospace Corp · Savannah, GABuilt 1978 · S/N AA5A0670N26717Dumpling Girls LLC · Concord, NCBuilt 1978 · S/N AA5A0671N26718Owen James T · Broken Arrow, OKS/N AA5A0673N2671CHouchen Chris F · Palmer, AKBuilt 1955 · S/N 35071N2671RCw Equipment Rentals Inc · Biggs, CABuilt 1967 · S/N 18258371N2671WSchwister Daniel Edward · Woodinville, WABuilt 1966 · S/N 3315N26722Neutren Glenn · Fort Bragg, CABuilt 1978 · S/N AA5A0675N26723Fulcrum Software Corp · Raleigh, NCBuilt 1978 · S/N AA5A0676N26725Registered aircraftS/N AA5A0678N26728Schmicker Robert A · Edmond, OKBuilt 1978 · S/N AA5A0680N2672CClipper Sky LLC · Las Vegas, NVS/N 35072N2672GPhillips Douglas S · Gloversville, NYBuilt 1959 · S/N 51972N2672MSchmoll Aviation LLC · Sterling, AKBuilt 1966 · S/N 18051729N2672Q4m Aviation LLC · Orting, WABuilt 1977 · S/N 28R-7737040N2672WGallatin Aviation Enthusiasts LLC · Fairbanks, AKBuilt 1966 · S/N 3316N2672XBird Nest Aviation LLC · Sheldon, IABuilt 1998 · S/N 18280305N2672YSchmieding Michael · Salem, ORBuilt 1962 · S/N 18051172N2672ZPuma Applied Science · Winchester, CABuilt 1977 · S/N 1007-78N26732Jefferies Jon F · Elk Grove Village, ILBuilt 1990 · S/N 90-301012N26733Givens Eric J · Frankfort, OHBuilt 1978 · S/N AA5A0605N26737Noser Thomas C · Bowling Green, KYBuilt 1978 · S/N AA5A0683N26738Hardy David G · Gilbert, SCBuilt 1978 · S/N AA5A0684N2673BM & N Of Alabama LLC · Magnolia Springs, ALBuilt 1980 · S/N 414A0630
Back to AD 2007-04-19 R1