OpenAirDocs.org
AD 2011-07-13

Registered aircraft · 523

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

N1808JNeissel Mark D · Gig Harbor, WAS/N 13028N1825JAction Interests Inc · Southlake, TXBuilt 1976 · S/N 13015N1858JKoenig Darrell Lee · Sumter, SCS/N 13031N1866JAnderson Dale · West Jordan, UTBuilt 1976 · S/N 13032N1882JMoody Bible Institute Of Chicago · Spokane, WABuilt 1976 · S/N 13034N1907JDaedal Flight LLC · Lancaster, SCBuilt 1976 · S/N 14007N191RLOpen Air Properties LLC · Jonesboro, ARS/N 14575N1920JDerrick James E · Godley, TXBuilt 1976 · S/N 14020N192DBTodd Tracy · Lancaster, SCBuilt 1976 · S/N 14021N192RGCinda Corporation · Lehighton, PABuilt 1992 · S/N 14561N1931JAerodyme Corp · South Burlington, VTBuilt 1976 · S/N 14031N1934JN1934j LLC · Highland Lakes, NJBuilt 1976 · S/N 14025N1937JBryant Joe Henry Jr · Meridian, MSBuilt 1976 · S/N 14037N1938JCsi Asset Management Inc · Naples, FLBuilt 1976 · S/N 14036N194BWCommander Aircraft Services Inc · West Palm Beach, FLS/N 14623N195TCPentz Larry Dean · Duvall, WABuilt 1995 · S/N 20001N1977JPicornell Francisco J · Malabar, FLBuilt 1976 · S/N 14080N197RCCaride Jose · Spring Hill, FLBuilt 1974 · S/N 197N19LHHollings Matthew C · Crowley, TXBuilt 1976 · S/N 14100N200CEBrewer Erich J · Thompson, MOBuilt 1977 · S/N 14257N202BKKucharski Bruce J · Pryor, OKBuilt 1976 · S/N 506N202RRNorton Edward A · Las Vegas, NVS/N 350N213EDAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 528N225ZMoe Kevin · West Chester, OHBuilt 2001 · S/N 20040N2270KCeyer Benno O · Downers Grove, ILBuilt 1976 · S/N 14182N2299BEximious Flying Club Inc · Ferndale, MIBuilt 1977 · S/N 14169N2299DCheri Lee Inc · Kulpmont, PABuilt 1977 · S/N 14230N231WFInternational Air Services Inc Trustee · Carson City, NVBuilt 2000 · S/N 14676N235PHSkyrider Anesthesia LLC · Saint Augustine, FLBuilt 2000 · S/N 14677N241GSmith Albert K · Pentwater, MIBuilt 1978 · S/N 14394N246PKGeneva1 Aviation LLC · Mars, PABuilt 1995 · S/N 20008N249PKVreeland James H · Bedford, PAFirst renewal noticeBuilt 1993 · S/N 14600N24BBSj Aviation LLC · Oxford, MIBuilt 1974 · S/N 157N254RNascar Aviation LLC · Silverado, CABuilt 1993 · S/N 14568N260BGLeonard Katherine A · Fresno, CABuilt 1977 · S/N 14238N269WGryphon LLC · Elbert, COS/N 14533N26HBBk Outlaws Inc · Myrtle Beach, SCBuilt 1978 · S/N 14379N27007Otstot Todd M · Boise, IDBuilt 1976 · S/N 483N27PWRampersad Paul R · Port Charlotte, FLBuilt 1995 · S/N 14641N292RGWashington Road Associates LLC · Dover, DEBuilt 1996 · S/N 20011N295TC295tc LLC · Cape Coral, FLBuilt 1996 · S/N 20012N29859Dangelo Thomas M · Plymouth, MIBuilt 1976 · S/N 14038N312BDOverton John W Jr · Minnetonka, MNBuilt 1994 · S/N 14612N31JTParker Ray · Claremont, NHS/N 14352N3219PShoot LLC · River Ridge, LAS/N 14243N321ABAmbrosini Alfred F · Connellsville, PABuilt 1979 · S/N 14523N324XFontenot Ira Dean · Collierville, TNBuilt 1975 · S/N 300N3296BCommand-Aire LLC · Coatesville, PABuilt 2000 · S/N 14673N395TCAqz Aviation Inc Trustee · Wilmington, DEBuilt 1995 · S/N 20003N4114BGrove Mark T · Cave Creek, AZBuilt 1993 · S/N 14598
Back to AD 2011-07-13