OpenAirDocs.org
AD 2012-03-52

Registered aircraft · 522

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:2012-03-52')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-03-52')
  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.

N1053LKutzleb Michael K · Fernandina Beach, FLBuilt 2000 · S/N 29-0261N1054CCumberland Curtis · Union Bridge, MDBuilt 2003 · S/N 29-0296N1054KBondy William G · Miami Beach, FLBuilt 2000 · S/N 29-0266N105PAPeck John A Jr · Shady Shores, TXBuilt 1997 · S/N 29-0107N1066UBurgoyne Wallace Carr Jr · Spring, TXBuilt 1994 · S/N 29-0005N1068GCanopy Ministries Inc · Mountain City, TNBuilt 2004 · S/N 29-0328N106TNSecond Wind Enterprises LLC · Atlanta, GABuilt 2008 · S/N 31-0106N108MBBuchinsky Stephanie Lynn · West Plains, MOBuilt 1994 · S/N 29-0008N111DDMoonrad LLC · Republic, MOBuilt 2006 · S/N 29-0471N111VSSite Development Inc · Mount Laurel, NJBuilt 1995 · S/N 29-0048N111WSM20r LLC · Centennial, COBuilt 2003 · S/N 29-0290N1129LFlyclem LLC · Brooklyn, NYBuilt 2008 · S/N 31-0078N113TNKn Air LLC · Sarasota, FLBuilt 2008 · S/N 31-0113N118MARussell Kenneth · Santa Cruz, CABuilt 2000 · S/N 29-0260N11VVSchmidt Milton W · Cincinnati, OHBuilt 1994 · S/N 29-0010N11YESky West Aviation Inc Trustee · Albuquerque, NMBuilt 1995 · S/N 29-0038N120GXLow & Slow Aviation Ventures LLC · Fort Myers, FLBuilt 2006 · S/N 29-0459N120TWAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 31-0057N121RPJohn A Rossi Inc · West Chester, PABuilt 1998 · S/N 29-0141N1234MDelta Mike Aviation LLC · Darien, CTBuilt 1997 · S/N 29-0127N123PZJanning Joe · Lebanon, OHS/N 31-0023N124ELerro Furey W · Wildwood, NJBuilt 2006 · S/N 29-0422N124EVEl Aero Services LLC · Verdi, NVBuilt 2005 · S/N 29-0382N127BSDemaagd Aviation LLC · Hickory Corners, MIBuilt 2005 · S/N 29-0378N12SNNechvatal Equipment Leasing LLC · Grand Blanc, MIBuilt 2007 · S/N 31-0019N12ZRMdw Rad Air LLC · Wilmington, DEBuilt 2007 · S/N 31-0073N132BGN132bg Corp Trustee · Wilmington, DEBuilt 2005 · S/N 29-0398N134MCByars John Jr · Houston, ALBuilt 1997 · S/N 29-0134N137PTXair LLC · Cloudcroft, NMBuilt 2008 · S/N 31-0115N142GXDicey Emery B · Port Orange, FLBuilt 2004 · S/N 29-0342N142KREal Properties · Vail, COS/N 31-0122N143ABMisch Keith · Staten Island, NYS/N 29-0400N143TMSchnautz Danny R · Pasadena, TXBuilt 2000 · S/N 29-0242N14ACLippert Bradley W · Crawford, COBuilt 1997 · S/N 29-0117N1525THamilton John D · Frederick, MDBuilt 2000 · S/N 29-0211N155DSJk Diamond Star LLC · Hillside, ILBuilt 2006 · S/N 29-0444N15PDHunter Philip · Great Falls, VABuilt 2007 · S/N 29-0492N15SPCavu LLC · Ames, IABuilt 2008 · S/N 31-0079N163DLMooplane LLC · Seattle, WABuilt 2007 · S/N 31-0055N169HWood Wendell · Holland, TXBuilt 2001 · S/N 29-0264N16PSAircraft Associates Inc · Tierra Verde, FLBuilt 2015 · S/N 31-0133N16RMBbj Aviation LLC · Shelby Township, MIBuilt 1997 · S/N 29-0112N189FA243 Kts LLC · Wilmington, DEBuilt 2008 · S/N 31-0089N190DRLehrke Thomas Alan · Bloomington, MNBuilt 2001 · S/N 29-0279N190TNMi-6 LLC · Helena, MTBuilt 2008 · S/N 31-0090N191KTLobianco John N · Woodmere, NYS/N 29-0280N192AGBp Aviation LLC · Gilbert, AZBuilt 2005 · S/N 29-0406N192JKWest Gregory B · Cummings, GABuilt 2004 · S/N 29-0353N194VUphoff Jeffrey A · Roanoke, VAS/N 29-0200N196GXRhodes David · Washington, DCBuilt 2006 · S/N 29-0414
Back to AD 2012-03-52