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.

N277MMSolan Richard J · Canaan, CTS/N 28-7325295N277MRSchab Davis Margaret A · Spangle, WABuilt 1966 · S/N TC-1012N277MTException LLC · Manning, SCBuilt 2022 · S/N 18283174N277MWEuroaviation Inc Trustee · KemBuilt 1974 · S/N 0544N277PDControlthings LLC · Hurricane, UTBuilt 2004 · S/N 10265N277PMRuley Paul B · West Lafayette, INBuilt 2018 · S/N 73461N277RBWaldo Pepper Flying Co · Wilmington, DEBuilt 1964 · S/N D-7473N277RDWestline Corp · Medina, OHBuilt 1978 · S/N 1156N277RKD O Aviation LLC · Wilmington, DES/N 13630N277RMSoutheast Design & Manufacturing LLC · Sun City Center, FLBuilt 1975 · S/N 28-7515354N277SAFox Matthew C · Athlone WestheathNon-citizen corporation, flight hours not reportedS/N 28-21661N277SLCharlies Wings LLC · Salisbury, NCBuilt 1973 · S/N 17261652N277SMKroha Michael D · Southbury, CTBuilt 1980 · S/N 28-8011072N277SSStone Scott · Hot Springs, ARBuilt 2023 · S/N 74956N277TVon Linsowe David J · Vero Beach, FLBuilt 1998 · S/N 24025-1N277TCTranslift Inc · Holly, MIBuilt 2005 · S/N 20608257N277TMPollock Donald Edward · Union Hall, VABuilt 1976 · S/N 18264391N277WWithnell Kurt W · Laguna Niguel, CABuilt 1992 · S/N 20505N277WLLozier Wesley · Farmington, ILBuilt 1977 · S/N D-10029N277WYKing Steven · Farmington, NMBuilt 2017 · S/N 3277N277XSalopek Rett · Las Cruces, NMBuilt 1977 · S/N 414-0925N27808St George Flight Academy LLC · St George, UTBuilt 1971 · S/N 17260023N2780GHolden Christa · Rougemont, NCBuilt 1958 · S/N 52080N2780XMontgomery Jeffrey L · Anthem, AZBuilt 1965 · S/N 18051580N2781DFejes Guide Service Ltd · Anchorage, AKBuilt 1979 · S/N 185-03892N2781JRussell Scott M · Sanger, TXBuilt 1969 · S/N 18501531N2781QGibboney Phillip M · Roseville, CABuilt 1967 · S/N 18257981N2781RBurley Robert L · Alliance, OHBuilt 1969 · S/N 28R-35272N2781WMaddox Robert P · Jarrell, TXBuilt 2010 · S/N P114N2781XN2781x LLC · Kingston, GABuilt 1965 · S/N 18051581N2782FMansoori Ali S · Aurora, COBuilt 1965 · S/N 18256882N2782QBauer Aviation LLC · Reese, MIBuilt 1967 · S/N 18257982N2783FVspp Consulting LLC · Stevensville, MDBuilt 1966 · S/N 18256883N2783GLarue Terrence W · Ellensburg, WABuilt 1959 · S/N 52083N2783TCloud 9 Aviators LLC · Anchorage, AKBuilt 1981 · S/N 18504350N2783WCrain James D · Hood River, ORBuilt 1966 · S/N 3361N2784GFlaps Up LLC · Kaysville, UTBuilt 1959 · S/N 52084N2784PStogner Michael E · Cuber0, NMBuilt 1955 · S/N 18-4418N2784TVerastegui Emilio F III · Albuquerque, NMBuilt 1967 · S/N D-8489N2784WBoeckman Thomas J · Carroll, IABuilt 1966 · S/N 3362N2784XGillett Welles III · Horseheads, NYBuilt 1965 · S/N 18051584N2785FAugustin Lyn H · Saint Thomas, NDBuilt 1966 · S/N 18256885N2785JDurtschi Steven R · Centerville, UTBuilt 1969 · S/N 185-1535N2785KPontiac Flying LLC · Pontiac, ILBuilt 1979 · S/N 18053067N2785MWood Gregory M · North Pole, AKS/N 12-1164N2785QA&R Aero LLC · Sacramento, CABuilt 1966 · S/N 32-688N2785RTorqerson Leif H · Cut Bank, MTBuilt 2007 · S/N 122N2785TPatin Carey · New Roads, LABuilt 1967 · S/N D-8501N2785WNienaber David K · Colorado Springs, COBuilt 1966 · S/N 1065N2786FChristoph Nicolas T · Okanogan, WABuilt 1966 · S/N 18256886
Back to AD 2007-04-19 R1