OpenAirDocs.org
AD 2007-06-01 R1

Registered aircraft · 257

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-06-01-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-06-01-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.

N1BDFloyds Aero Inc · Amarillo, TXS/N G-91N2042YPierson Daniel D · Kalispell, MTS/N G-826N20MLong David M · Schaumburg, ILBuilt 1983 · S/N BG-204N2188TWeaver Aircraft Co · Carson City, NVS/N BG-188N21970Weaver Aircraft Co · Carson City, NVS/N BG-197N234FS234fs LLC · Ponte Vedra Beach, FLBuilt 1955 · S/N 53-4132N234MBSonday Terrance P · Red Lodge, MTBuilt 1956 · S/N BG-199N234MCStauffer Charles I · Battle Creek, MIS/N BG-411N234TUMid Continent Aircraft Corp · Hayti, MOBuilt 1953 · S/N G-138N248RPPatterson Robert F · Buckley, WABuilt 1958 · S/N FM84-1N256GRRicciotti Gerard · Annapolis, MDBuilt 1956 · S/N G-754N256NNichols Richard C · Port Orange, FLS/N BG-398N266JDJ D Deboskey Inc · Palm Beach Gardens, FLS/N G-810N268AFApogee Flight Inc · Bellingham, WABuilt 1961 · S/N G-828N26KGarrett Robert A · Dallas, GABuilt 1954 · S/N G-57N273CBGause Timothy L · Georgetown, SCBuilt 1953 · S/N G-72N27634Middaugh Terry E · Chattaroy, WABuilt 1952 · S/N G-15N287JTA W Aviation · Sevierville, TNBuilt 1953 · S/N G-287N28CNRoman Stephen B · Minnetrista, MNBuilt 1976 · S/N CN-1N2969CCollins Gordon Lee · Knoxville, TNS/N G-155N2VDFloyds Aero Inc · Amarillo, TXS/N G-784N2VYSmith William E Jr · Havre De Grace, MDBuilt 1955 · S/N BG-67N326FWWilliam Keith Stockman · Port Orange, FLBuilt 1957 · S/N BG-326N32EEMcginnis Patrick J · Friendswood, TXBuilt 1953 · S/N 53-4092N334FCavu Aviation LLC · Hickory, NCBuilt 1961 · S/N BG-316N334HCCannon Harold · Utica, KYS/N 34-69N334JVTharp Donald J · Aurora, OHBuilt 1957 · S/N BG-366N334LSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1956 · S/N G-813N334RLButters Brewster S · Port Orange, FLBuilt 1963 · S/N G-12N334TFlying Crown Aviation LLC · Fond Du Lac, WIBuilt 1955 · S/N BG-138N334TTWeaver Aircraft Co · Carson City, NVBuilt 1958 · S/N GM-194N334TXMagic Mentor LLC · Canyon, TXS/N G-26N3403FScala Peter M · Port Orange, FLS/N BG-408N341MRRussell Marc R Trustee · Simi Valley, CABuilt 1955 · S/N BG-65N341TSSecond Delaware Corp · Moorestown, NJBuilt 1955 · S/N G-773N3424AHarrison Dan · Englewood, FLS/N 34-24N342DBBeitler William · Washington, PABuilt 1999 · S/N G107N343DBBrown Patrick T Trustee · Osceola, WIBuilt 1957 · S/N BG-317N343ZMBuzzard Aviation LLC · St Simons Island, GABuilt 1955 · S/N G-303N344SGGoldman Glenn D · VaughanBuilt 1957 · S/N BG354N34AFHangar 6 Aviation LLC · Destin, FLBuilt 1954 · S/N 34-51N34AQZimmerman Steven W · Olathe, KSBuilt 1956 · S/N CG112N34ATField Kent · Santa Barbara, CABuilt 1957 · S/N G-139N34BAPrvny Pluk LLC · Houston, TXBuilt 1956 · S/N G-797N34BVDessuit Franklin Jr · Mckinney, TXBuilt 1956 · S/N CG-152N34BZDimich Milan C · Madison, SDBuilt 1958 · S/N CG-209N34CRRounds Donald C DBA · Waller, TXS/N G-758N34DKTennessee Aviation Services LLC · Sevierville, TNBuilt 1962 · S/N G-744N34DTSutton William E · Salinas, CABuilt 1953 · S/N G-114N34DYMccormick Daniel · Salem, SCBuilt 1956 · S/N G-730
Back to AD 2007-06-01 R1