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.

N34HDWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1984 · S/N 17276259N34HEHaltitude Aviation LLC · Colorado Springs, COBuilt 1956 · S/N BG-165N34HJGeissler Henry · Webster, MNBuilt 1999 · S/N 2317N34HLDiller Calvin D · Hillsboro, ORBuilt 1995 · S/N 22126N34HUCartrite Kerry G · Amarillo, TXBuilt 2013 · S/N 3194N34JAN47me LLC · Tampa, FLBuilt 1979 · S/N 6005867961189N34JCA2b Aviation LLC · Newark, OHBuilt 1978 · S/N 32-7840198N34JPDakota Aircraft Inc · Pierre, SDBuilt 1973 · S/N CJ-39N34JSJ & K Aviation LLC · Bristow, OKBuilt 1976 · S/N 18264675N34JTShowerman Mike T · Urbana, ILS/N 14JTN34JWRounds Donald C · Waller, TXS/N BG374N34KCh Aviation LLC · Wilmington, DEBuilt 1981 · S/N 18504349N34KBReilly Donald H · Micco, FLBuilt 1978 · S/N 21062656N34KCCantrell Kenneth P · Lodi, CABuilt 2002 · S/N 60260N34KDLofty Aspirations LLC · Bozeman, MTBuilt 2008 · S/N 3033N34KFRsb Properties LLC · Lewes, DES/N P21000700N34KJWright Wing Aviation LLC · Pittsboro, NCBuilt 1961 · S/N G-715N34KMBravo Adventures LLC · Scottsdale, AZBuilt 1981 · S/N EA-207N34KRH & H Air Inc · Washington, INBuilt 1956 · S/N G-766N34LRanney Jeffrey A · Princeton, MNBuilt 1972 · S/N 537N34LCC & J Air Inc · Middletown, DEBuilt 1979 · S/N 17272203N34LGCruz Aviation LLC · Holmdel, NJBuilt 2021 · S/N 18283145N34LHHilderbrand Terry J · Lodgepole, NEBuilt 2001 · S/N 47MN34LLGwizz Financial LLC · Wausau, WIBuilt 1976 · S/N 24-0047N34LVRegistered aircraftBuilt 1968 · S/N 17257507N34LWAnderson Glenn L · Sandia Park, NMBuilt 1956 · S/N BG-160N34MKBadger Industries LLC · Harvard, ILBuilt 1953 · S/N G-88N34MMSchubee Air Inc · Watkins, COBuilt 1967 · S/N 401-0125N34MRN34mr LLC · Orlando, FLBuilt 1952 · S/N G-39N34MTPerigee Investments LLC · Anacortes, WAS/N BG-417N34MVElysium Fleet Mgmt LLC · Menlo Park, CABuilt 1983 · S/N 32R-8413006N34MXEwald Robert H · Red Lodge, MTBuilt 1984 · S/N PG-114N34NCSpencer Coastal Air LLC · Ellsworth, MEBuilt 1979 · S/N 18503886N34NDDavis Jeffery S · Oregon City, ORBuilt 2000 · S/N 5407N34NYKeys Robert · Menifee, CABuilt 1973 · S/N 340-0196N34PACosentino William D · Lees Summit, MOBuilt 1955 · S/N G-268N34PDDonner Paul A · Hurst, TXBuilt 1981 · S/N 45N34PPPeters Patrick J · Wasilla, AKBuilt 2005 · S/N 20952N34PTJentone Aviation LLC · Aber Prov Grd, MDBuilt 1974 · S/N 28R-7535029N34PZPitts S2-B Aero LLC · Newport Beach, CABuilt 1983 · S/N 5022N34RInfinity Welding And Fabrication LLC · Celina, TXBuilt 2002 · S/N L2K-174N34RABurke William G III · Fayetteville, GABuilt 1964 · S/N 30-342N34SAMiller Keaton · Newburgh, INBuilt 1978 · S/N 24-0428N34SCTbhb Logistics LLC · Amarillo, TXBuilt 1978 · S/N TH-943N34SFStults Curt M · Oklahoma City, OKBuilt 1959 · S/N 18-7141N34SLAnderson Aerial Spraying Service Inc · Canby, MNS/N LE001N34SPPollard Stephen J · Park City, UTBuilt 2016 · S/N 5118N34SRL-Bird LLC · Hood River, ORBuilt 1963 · S/N 18255005N34SWCobb James E · Collierville, TNBuilt 1979 · S/N R18201077N34SYGeneral Aviation Modifications Inc · Ada, OKBuilt 1956 · S/N BG-246
Back to AD 2007-04-19 R1