OpenAirDocs.org
AD 68-23-08

Registered aircraft · 87

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:68-23-08')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:68-23-08')
  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.

N11811Anderson Russell W · Blackfoot, IDBuilt 1967 · S/N 30024N1260RLife Builders International · Albert Lea, MNBuilt 1967 · S/N 4332N1262RKullmann Richard · Encinitas, CAS/N 4336N198VSkrow Works Inc · West Monroe, LABuilt 1969 · S/N 30214N425BBGarcia Robert Lee · Horseshoe Bay, TXBuilt 1968 · S/N 30099N4702VBrown Anthony · Pacoima, CABuilt 1967 · S/N 30053N4703VLangham William Hb · Uvalde, TXBuilt 1967 · S/N 30054N4714VSwanland Robert C · Grants Pass, ORBuilt 1967 · S/N 30069N4716VFields William F · Hazard, KYBuilt 1967 · S/N 30068N4720VBurr Philip A · Bethel, CTBuilt 1967 · S/N 30060N4733VEdwards James W · Del Norte, COBuilt 1967 · S/N 30066N4736VRegistered aircraftBuilt 1967 · S/N 30067N4744VSettle David A · Lyons, KSBuilt 1967 · S/N 30073N4745VFiecke Rodney J · Cokato, MNS/N 30074N4747VRegistered aircraftBuilt 1967 · S/N 30036N4799VDeparture Aviation Services LLC · Laurel Hill, NCS/N 30088N4802VWilcox Chad R · Muncy Valley, PABuilt 1967 · S/N 30082N4822VCantrell David R · Albany, GABuilt 1968 · S/N 30092N4830VAkin Allen Kent · Midland, TXBuilt 1968 · S/N 30095N4847VNutter Michael S · University Place, WABuilt 1968 · S/N 30102N4855VGlide Slope Aviation Inc · Myakka City, FLBuilt 1968 · S/N 30109N4865VWoltjer Richard J · Pennock, MNBuilt 1968 · S/N 30110N4876VGrothe Loren L · Willmar, MNBuilt 1968 · S/N 30118N4880VVillage Motors Inc · Lake Village, INS/N 30122N4887VJennings Delbert Keith · West Fargo, NDBuilt 1968 · S/N 30128N4888VBarrett James Michael · Concordia, KSBuilt 1967 · S/N 30065N4892VPonto Michael A · Edgewood, NMBuilt 1968 · S/N 30131N4915VPegasus Aviation LLC · Rogersville, MOS/N 30139N4941VClark Robert J · Brookshire, TXS/N 30146N4946VJennings Carl M · Au Gres, MIS/N 30148N6385HEds Used Machinery LLC · Memphis, MOS/N 30104N6559VDodson International Parts Inc · Rantoul, KSBuilt 1969 · S/N 30248N6566VRiley Shawn P · Saint Paul, MNBuilt 1969 · S/N 30252N6570VHildreth Jay · Wamego, KSBuilt 1969 · S/N 30257N6574VHandke Robert C · Atchison, KSBuilt 1969 · S/N 30250N6582VMonroe Robert Sean · Oceanside, CABuilt 1969 · S/N 30256N6600VLeahy Thomas J · Marblehead, OHBuilt 1970 · S/N 30261N6607VGlovier George G · Pocomoke City, MDBuilt 1970 · S/N 30262N6650VHarris Willis J · Letts, IABuilt 1966 · S/N 30001N6651VDunbar Stephen E Trustee · Broken Arrow, OKBuilt 1966 · S/N 30003N6652VLaughlin David E · Rapid City, SDS/N 30005N6662VOlson Larry L · Timmonsville, SCBuilt 1967 · S/N 30026N6665VBetts Miley F · Highlands Ranch, COBuilt 1967 · S/N 30035N6670VCollum Aviation LLC · Milton, FLS/N 30021N6675VBrazier Glen A · Greenbush, MNBuilt 1967 · S/N 30033N6677VFandrich Abraham L · Clancy, MTS/N 30020N6685VHeirborne LLC · Kansas City, MOS/N 30041N6686VRegistered aircraftBuilt 1967 · S/N 30050N6687VOsterberg Douglas L · Neenah, WIBuilt 1967 · S/N 30029N6688VBesch Marvin Eugene II · Redmond, WABuilt 1967 · S/N 30017
Back to AD 68-23-08