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.

N10006Coutches Robert Hercules DBA · Livermore, CABuilt 1955 · S/N BG-72N100ZPZipjack Inc · Fernandina Beach, FLBuilt 1955 · S/N BG-4N102PSHunt Jimmie · Leary, GABuilt 1953 · S/N G-76N10319Battle Creek Aero Club Inc · Kalamazoo, MIBuilt 1957 · S/N BG-318N10554T34sum LLC · Lake In The Hills, ILS/N CCF-34-37N111LKBrewer Mike R · Cameron Park, CABuilt 1955 · S/N G-724N111VNDs Flight Services LLC · Battle Ground, WABuilt 1962 · S/N G-815N1218Nogle Charles H · Champaign, ILBuilt 1956 · S/N BG-163N121BCCavanaugh Collections Inc · Addison, TXS/N G-123N12250Renforth Michael · Yorktown, VABuilt 1955 · S/N G-701N12252Maresco International Corp · Alpha, NJBuilt 1965 · S/N G-704N12253Breitenstine Matthew · Dallas, TXS/N G-705N12255Cirrus Management LLC · Suwanee, GAS/N G-707N12258Bacon Otis Blake · Fremont, CABuilt 1955 · S/N G-722N12264Enk William A Sr Trustee · Blue Springs, MOBuilt 1956 · S/N G-818N12275Bachman Mildred R · New Brighton, PABuilt 1965 · S/N G-263N12281Flippen John P · Bonita, CABuilt 1955 · S/N G-293N12BDChaos Aviation LLC · Warrenton, VAS/N G-116N134Mccann Thomas J Jr · Jackson, WYBuilt 1953 · S/N 53-4135N134ASmith Douglas O · Corvallis, ORBuilt 1952 · S/N G-59N134AFSummerfield Douglas T · Mason City, IABuilt 1953 · S/N G-100N134BLOvaert Daniel L · Tryon, NCS/N BG-53N134CDL&L Aviation Inc · Advance, NCBuilt 1955 · S/N G-717N134DVac Sys Holdings LLC · Roseville, CAS/N G-743N134DHBohlig Stephen W · Minnetonka, MNBuilt 1953 · S/N 34-78N134DRRothenanger David A · Talladega, ALBuilt 1956 · S/N BG-169N134GLWhiskey Tango Aviation LLC · Owasso, OKBuilt 1955 · S/N G-732N134HRL&P Of Mke LLC · Milwaukee, WIBuilt 1955 · S/N G-745N134JCClark Julie E · Cameron Park, CAS/N G-812N134JVVance John C · Coleman, TXS/N BG-345DCN134KCKw Plastics · Troy, ALBuilt 1953 · S/N G-78N134LCConklin Lynn A · Vacaville, CABuilt 1953 · S/N 53-4149N134MBLarsen Matthew J · Filer, IDS/N G-83N134RHCarlton John B · Lenoir, NCS/N BG-31N134RRRussell Jon D · Calabasas, CABuilt 1957 · S/N BG-340N134SBBaksa Stephen D · Chatham, NJS/N CN3N134SMCzech Six LLC · Lafayette, LABuilt 1957 · S/N BG-312N134TTPlane Fun Inc Tr Trustee · Snellville, GABuilt 1953 · S/N G-305N13JGJones Eric M · Keller, TXBuilt 1953 · S/N G-297N13TLittle Texan LLC · Brighton, MIS/N G-79N13WBRodgers Harold Lynn Jr · Mckinney, TXBuilt 1956 · S/N BG-145N143PDSouder James B · Port Orange, FLBuilt 1953 · S/N 53-4134N145SBBaksa Stephen · Chatham, NJBuilt 1956 · S/N G-148N157ZLBrooks Aviation Inc · Douglas, GAS/N BG-355N158ZLOlds Curtis J Jr · Elizabeth City, NCBuilt 1957 · S/N BG-344N15DMFowler Bruce Jr · Cedar Park, TXBuilt 1955 · S/N G-702N15MCAir Heritage Inc · Beaver Falls, PABuilt 1956 · S/N BG-295N168AFApogee Flight Inc · Bellingham, WABuilt 1953 · S/N G-299N18255Registration Pending · Los Olivos, CARegistration pendingS/N G-739N183BWilliams John · Omaha, NES/N BG-414
Back to AD 2007-06-01 R1