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.

N4486YQuality Aviation Inc · Marana, AZBuilt 1966 · S/N 25-4147N4487YWitthuhn Johnie B · Callaway, NEBuilt 1966 · S/N 25-4150N4490YMinnesota Soaring Club Inc · Stanton, MNBuilt 1966 · S/N 25-4154N4494YBegrow Adroaldo D · Gulf Shores, ALBuilt 1966 · S/N 25-4161N4495YMerlin Soaring Association Inc · Amelia Court House, VABuilt 1966 · S/N 25-4162N4496YHill Kenneth G · Pocatello, IDBuilt 1966 · S/N 25-4166N4512YNohrenberg Redge O · Pingree, NDBuilt 1966 · S/N 25-4078N4513YAlbertson James M · Slocomb, ALBuilt 1966 · S/N 25-4019N4515YArthur Aviation LLC · Arthur, NDBuilt 1966 · S/N 25-4148N4517YHoffmann Earl R Jr · Wildwood, MOBuilt 1966 · S/N 25-4167N4521YKron Howard H · Clara City, MNBuilt 1966 · S/N 25-4072N4522YAerial Messages Leasing Co · Longwood, FLBuilt 1966 · S/N 25-4030N4530YSchindler Rick M · Neligh, NEBuilt 1966 · S/N 25-4143N4538YKnutson Wayne R · Thompson, NDFirst renewal noticeBuilt 1967 · S/N 25-4184N454ABAerial Banners North Inc · Pembroke Pines, FLBuilt 1974 · S/N 25-7556048N4550YMiller Andy D · Marana, AZS/N 25-4201N4562YEd Air Inc · Oaktown, INBuilt 1967 · S/N 25-4186N4569YDebilt Bruce A · Berthold, NDBuilt 1967 · S/N 25-4232N4571YDavis James J · Beaver Dam, WIBuilt 1967 · S/N 25-4235N4586YRiggin Flight Service Inc · Madison, SDBuilt 1967 · S/N 25-4264N4593YSoaring Society Of Boulder · Boulder, COBuilt 1967 · S/N 25-4278N4606YAdirondack Soaring Association Inc · Ballston Spa, NYBuilt 1967 · S/N 25-4303N4618YEagleville Soaring Club · Eagleville, TNBuilt 1967 · S/N 25-4324N4624YBowers James E DBA · Galloway, OHBuilt 1967 · S/N 25-4337N4625YAir Sailing Inc · Reno, NVBuilt 1967 · S/N 25-4339N4629YBarts Flying Service Inc · Storm Lake, IABuilt 1967 · S/N 25-4346N4642YFriends Aviation Inc · Wilmington, DEBuilt 1967 · S/N 25-4361N4652YDakota Acre Farms Inc · Denhoff, NDBuilt 1967 · S/N 25-4372N4669YHollister Soaring Center LLC · Hollister, CABuilt 1967 · S/N 25-4392N4691YSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1967 · S/N 25-4422N4693YKnutson Wayne R · Thompson, NDBuilt 1967 · S/N 25-4424N4699YSandhill Soaring Club Inc · Brighton, MIBuilt 1967 · S/N 25-4417N4707YWengair LLC · Powell, WYBuilt 1967 · S/N 25-4439N4721YHendrickson Flying Service Inc · Rochelle, ILBuilt 1967 · S/N 25-4463N4722YX-C Soaring Association Inc · Pensacola, FLBuilt 1967 · S/N 25-4465N4732YChilhowee Soaring Association Inc · Benton, TNS/N 25-4480N4736YHollatz Walter M · Concord, GABuilt 1967 · S/N 25-4488N4748YMemphis Soaring Society · Memphis, TNBuilt 1968 · S/N 25-4504N4772YKnutson Wayne R · Tioga, NDBuilt 1968 · S/N 25-4535N4780YPhiladelphia Glider Council · Hilltown, PABuilt 1968 · S/N 25-4548N4784YBig Sky Jet Inc · Bozeman, MTBuilt 1968 · S/N 25-4553N4785YSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1968 · S/N 25-4556N4792YAerial Banners Inc · Pembroke Pines, FLBuilt 1968 · S/N 25-4568N4794YAir Kraft Spraying Inc · Timber Lake, SDBuilt 1968 · S/N 25-4572N4795YPiper 4795y Aviation Services LLC · Colorado Springs, COBuilt 1968 · S/N 25-4573N4800PFun Country Soaring · Avon Lake, OHBuilt 1968 · S/N 25-4580N4807YMayes Noelle C · Williams, CAS/N 25-4555N4811YSale Reported · Dover, DESale reportedBuilt 1968 · S/N 25-4592N4812YRc Ag Air LLC · Cairo, MOS/N 25-4594N4814YKnerr Joshua D DBA · Tehachapi, CAS/N 25-4597
Back to AD 2007-08-07