AD 2007-08-07

Registered aircraft · 454

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-08-07')
    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-08-07')
  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.

N4815YAdrian Soaring Club Inc · Ypsilanti, MIBuilt 1968 · S/N 25-4567N4817YQuality Aviation Inc · Marana, AZBuilt 1968 · S/N 25-4601N4825YHall William B · Vincentown, NJBuilt 1968 · S/N 25-4614N4827YThief River Aviation Inc · Thief River Falls, MNBuilt 1968 · S/N 25-4618N4832YStohr Beuford G · Woden, IABuilt 1968 · S/N 25-4626N4838YWagner Nathan D · Dane, WIBuilt 1968 · S/N 25-4634N4840YDmc Aircraft LLC · Naples, FLBuilt 1968 · S/N 25-4637N4841YBlack Forest Soaring Society · Monument, COS/N 25-4639N4856YAgland Air Inc · Beaver Dam, WIBuilt 1968 · S/N 25-4657N4860YAerial Banners Inc · Pembroke Pines, FLBuilt 1968 · S/N 25-4662N4862YKohler Richard L · Moriarty, NMBuilt 1968 · S/N 25-4665N4873YCherry Hill Aviation Inc · Freetown, INBuilt 1968 · S/N 25-4675N4897YKnutson Wayne R · Tioga, NDBuilt 1968 · S/N 25-4704N4898YSimmons Mark Adba · Pawcatuck, CTBuilt 1968 · S/N 25-4705N4923YDenton Aerial Spraying Inc · Las Animas, COBuilt 1968 · S/N 25-4620N4926YDenton Aerial Spraying Inc · Las Animas, COBuilt 1968 · S/N 25-4724N4928YSpragues Aerial Spraying Inc · Courtenay, NDBuilt 1968 · S/N 25-4727N4938YAerial Banners Inc · Pembroke Pines, FLBuilt 1968 · S/N 25-4738N4964YFowler Larry K · Harrison, ARBuilt 1968 · S/N 25-4676N4966YSchmitt Rudy · Brookshire, TXBuilt 1968 · S/N 25-4767N4977YQuality Aviation Inc · Marana, AZBuilt 1968 · S/N 25-4748N4983YCaprock Soaring Association · Lubbock, TXBuilt 1968 · S/N 25-4787N4988YVan Kleek Steve D · Milford, IABuilt 1968 · S/N 25-4797N50TPSoar Utah Inc · Heber City, UTS/N 25-2341N54000Entropic Synergies LLC · Visalia, CAS/N 25-7405573N54879Shaw Brian · Granada, COS/N 25-7656025N54881Huntsville Soaring Club · Brownsboro, ALBuilt 1976 · S/N 25-7656027N54898Central Indiana Soaring Society · Yorktown, INBuilt 1976 · S/N 25-7656032N54904Quality Aviation Inc · Marana, AZS/N 25-7656033N54909Soaring Society Of Dayton Inc · Waynesville, OHBuilt 1976 · S/N 25-7656049N54914Csa Foundation Inc · Wellington, COBuilt 1976 · S/N 25-7656055N54915Mohawk Soaring Club Inc · Hoosick Falls, NYBuilt 1976 · S/N 25-7656056N6016ZPrestenbach Kyle A · Vacherie, LAS/N 25-19N6021ZAerial Banners Inc · Pembroke Pines, FLS/N 25-25N6035ZAerial Banners Inc · Pembroke Pines, FLBuilt 1959 · S/N 25-42N6047ZValley Soaring Club · Middletown, NYBuilt 1959 · S/N 25-54N6049ZLockwood Shawn O · Volborg, MTBuilt 1959 · S/N 25-56N6052ZJackson Paul D · Phoenix, AZBuilt 1959 · S/N 25-59N6053ZSlack Brenda · Norfolk, VABuilt 1959 · S/N 25-60N6058ZBlackstone Aircraft LLC · Hartselle, ALBuilt 1960 · S/N 25-18N6079ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1960 · S/N 25-91N6112ZLowry Wilson R · Leonardtown, MDBuilt 1960 · S/N 25-130N6120ZH & H Ag Aviation Inc · New Underwood, SDBuilt 1960 · S/N 25-140N6125ZSvendsen Jon A · Wasilla, AKBuilt 1960 · S/N 25-145N6126ZKistler Stephen M · Monument, KSBuilt 1960 · S/N 25-147N6127ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1960 · S/N 25-148N6140ZConnecticut Soaring Association Inc · New London, CTS/N 25-164N6141ZRotor And Wing · Tioga, NDBuilt 1960 · S/N 25-165N6151ZRotor And Wing LLC · Tioga, NDBuilt 1960 · S/N 25-177N6175ZSpot-Air LLC · Burlington, TXBuilt 1959 · S/N 25-208
Back to AD 2007-08-07