OpenAirDocs.org
AD 76-23-03 R1

Registered aircraft · 559

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:76-23-03-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:76-23-03-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.

N4714VSwanland 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 30088N479SVKollstedt Lance S · Tipp City, OHBuilt 1979 · S/N 79-30950N4802VWilcox 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 30139N492TCMckinley Matthew · Sault Sainte Marie, MIBuilt 1971 · S/N 30362N4941VClark Robert J · Brookshire, TXS/N 30146N4946VJennings Carl M · Au Gres, MIS/N 30148N495RFStewart Delbert G · Kent, OHBuilt 1973 · S/N 73-30613N501CRTarno Suzzan · Avondale, AZBuilt 1973 · S/N 73-30607N51LHAlger David W · Lago Vista, TXS/N 98-301027N53CWBeitel Theodore C · Higden, ARBuilt 1996 · S/N 96-301024N5683UMccarver Tyler L · Wharton, TXS/N 73-30500N575JHDunbar Stephen E Trustee · Broken Arrow, OKBuilt 1975 · S/N 75-30791N577BLLee Bryan Steven · Lubbock, TXBuilt 1973 · S/N 74-30648N579SVTorrey Daniel B · Santa Paula, CABuilt 1979 · S/N 79-30952N57DYClair William E Jr · Casper, WYBuilt 1978 · S/N 78-30867N611DCWhite John D · Rockwall, TXS/N 79-30942N617JMTravland Christopher · Austin, TXBuilt 1976 · S/N 76-30845N623AMMelgar Albert T · El Paso, TXBuilt 1979 · S/N 79-30928N625RLPerry James Edward · Cleveland, GABuilt 1979 · S/N 79-30960N63026Hacker Jr Delbert M · Granbury, TXBuilt 1984 · S/N 84-30989N6302XGelaude James J · Lakewood, COS/N 84-30988N63083Kearney Charles B III · Argyle, TXBuilt 1984 · S/N 84-30992N6312YSellers Mark R · Philadelphia, PAS/N 85-30993N6314ZWilliam T Murphy Investigations Inc · Stillwater, MNBuilt 1985 · S/N 85-30996N6315VGiroux Michael J · Trophy Club, TXBuilt 1985 · S/N 85-30995N6316VGardoski Mark · Dayton, NVS/N 87-30998N6385HEds Used Machinery LLC · Memphis, MOS/N 30104N6556VGiannola Peter S · San Diego, CAS/N 32-15N6559VDodson International Parts Inc · Rantoul, KSBuilt 1969 · S/N 30248N6566VRiley Shawn P · Saint Paul, MNBuilt 1969 · S/N 30252N6570VHildreth Jay · Wamego, KSBuilt 1969 · S/N 30257
Back to AD 76-23-03 R1