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.

N42852Fisch Kurt D · Riverside, CABuilt 1968 · S/N 18259215N42855Wojteczko Jason A · Derby, KSS/N 18259216N4285HPralle Jeffory K · Wasilla, AKBuilt 1948 · S/N 14-90N4285QShielded Holdings LLC · Katy, TXBuilt 1971 · S/N 17260185N4285TBuenger Michael · Gilbert, AZBuilt 1971 · S/N 28-7205056N4285ZYoseph Barry L · Olympia, WABuilt 1967 · S/N 18-8534N42865Skylane Partners LLC · Duvall, WABuilt 1968 · S/N 18259224N428663 Elm Terrace LLC · Waterville, MEBuilt 1974 · S/N 34-7450173N42867Burns Charles R · Huntsville, ALBuilt 1974 · S/N 28-7425319N4286PGress Gabrielle M · Davenport, FLBuilt 1959 · S/N 23-1786N4286ZMalcolm Rodgers K Jr · Belzoni, MSS/N 18-8599N42871Registered aircraftBuilt 1968 · S/N 18259226N42874Kloker Daniel E · Owasso, OKBuilt 1968 · S/N 18259227N42875Bowes Tyler D · Fremont, OHBuilt 1968 · S/N 18259228N42876Norcal Flight Center LLC · Lincoln, CABuilt 1968 · S/N 18259229N42877Allain Patrick C · Brusly, LABuilt 1968 · S/N 18259230N42879Bartle Henry Trustee · Independence, ORBuilt 1992 · S/N 1N4287AWilliam Dolson And Associates LLC · Santa Fe, NMBuilt 1980 · S/N 340A1010N4287JBillingsley Steven M · Prosperity, SCBuilt 1967 · S/N 28-22651N4287QMonmouth Area Flying Club · Lakewood, NJBuilt 1971 · S/N 17260187N4287SLemanski Joseph S · Fiskdale, MABuilt 1977 · S/N TC-2112N4287TJonair LLC · Charleston, SCBuilt 1971 · S/N 28-7110026N4287ZCazac Connor · Kenai, AKBuilt 1967 · S/N 18-8536N42885Sisca John A · Gilbert, AZBuilt 1974 · S/N 28-7415403N42887Bratlien Michael D · Aurora, COBuilt 1968 · S/N 18259234N42888Ahigian Craig S · Laguna Niguel, CABuilt 1968 · S/N 18259235N42889Fuller Lawrence A · Wasilla, AKBuilt 1973 · S/N 18052382N4288HHoogendorn Homer E · Wasilla, AKBuilt 1948 · S/N 14-78N4288PMooradian Edward M · Fowler, CABuilt 1968 · S/N 18259194N4288QN4288q LLC · Myrtle Beach, SCBuilt 1971 · S/N 17260188N4288ZAltobelli Matthew J · Dover, PABuilt 1967 · S/N 18-8601N42893Registration Pending · El Paso, TXRegistration pendingBuilt 1968 · S/N 18259239N42894Comal Aero Inc · Schertz, TXBuilt 1968 · S/N 18259240N42898Perera Austin L · Barnstable, MABuilt 1968 · S/N 18259242N42899Smith Charles Max · Canon City, COBuilt 1968 · S/N 18259243N4289HGiguere Michael R · Danielson, CTBuilt 1978 · S/N 24-0696N4289JMiller Curtis L · Brownstown, PABuilt 1967 · S/N 28-22654N4289THohm Harold C · Chicago, ILBuilt 1971 · S/N 28-7205133N428AJetpropmontana LLC · Cameron, MTBuilt 1986 · S/N 4608031N428ACMckinley Nathan C · New Braunfels, TXBuilt 2000 · S/N 1288-2000N428AKOlsen Martin G · Anchorage, AKBuilt 1976 · S/N 18502917N428BBPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010046N428BLFlying Money Pit LLC · Des Moines, IABuilt 1965 · S/N 18256552N428CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 2001 · S/N 172S8690N428CTInda Trygve H · Sparks, NVBuilt 1979 · S/N 28-7911155N428DDJulius Donald D · Rollins, MTBuilt 2011 · S/N 1407N428DKKugler Donald W Jr · Baptistown, NJBuilt 2003 · S/N 80608N428DLGiair LLC · Morristown, TNBuilt 1976 · S/N 310R0657N428DMCochran Michael S · Centennial, COBuilt 1995 · S/N 428N428DWArizona Cloudbusters Inc · Mesa, AZBuilt 2001 · S/N 172S8708
Back to AD 2007-04-19 R1