OpenAirDocs.org
AD 59-07-05

Registered aircraft · 345

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

N119EAce Aeromotive Inc · Miami, FLBuilt 1958 · S/N 24-532N1220ZColumbus State Community College · Columbus, OHBuilt 1959 · S/N 24-800N124NREckhoff Daniel · Ramsey, MNBuilt 1960 · S/N 24-1839N136YJanoski David M · Fort Worth, TXBuilt 1960 · S/N 24-1991N144TLNielson Mark Allen · Willmar, MNBuilt 1959 · S/N 24-1205N15QAQuiet Aero LLC · Fort Myers, FLBuilt 1960 · S/N 24-2388N160LMMino Leonard G · Pueblo West, COBuilt 1958 · S/N 24-79N175MBKlein Robert · North Garden, VABuilt 1959 · S/N 24-721N180MLBearden Harold H · Haleyville, ALBuilt 1961 · S/N 24-2609N199JTPena Rivera Luis A · Zephyrhills, FLBuilt 1960 · S/N 24-2323N2024PYounhorsh Sales LLC · Wilmington, DEBuilt 1956 · S/N 24-1N20RDickerson Stephen R · Frisco, TXBuilt 1960 · S/N 24-1684N23BMAxiom Development And Consulting LLC · Atlanta, GABuilt 1959 · S/N 24-1118N2456PMc Elheny Michael J · Canton, GABuilt 1962 · S/N 24-3153N2SVPiper J D · Lawrenceville, ILBuilt 1963 · S/N 24-3428N325CVajdos Nicholas · Karnes City, TXS/N 24-1082N3764XAerialsmith LLC · Dunedin, FLS/N 24-4973N38AGBaxter Kyle W · Tumwater, WABuilt 1959 · S/N 24-1259N3MSCarter Zac · Atlanta, GABuilt 1960 · S/N 24-1747N3SDDanish John S · Hooksett, NHBuilt 1958 · S/N 24-380N43TLT M L Aircraft Inc · Narrowsburg, NYBuilt 1971 · S/N 24-5001N45MBWright Kelly A · Spokane, WABuilt 1959 · S/N 24-1445N47BBRogers Joseph O III · Fernandina Beach, FLBuilt 1960 · S/N 24-1889N5002POrtman Bernard · Deer Park, TXBuilt 1957 · S/N 24-5N5003PLouwagie Bradley J · Marshall, MNBuilt 1957 · S/N 24-6N5005PRackley William R Jr · Grand Island, FLBuilt 1957 · S/N 24-8N5006PWright William · Cleveland, OKBuilt 1957 · S/N 24-9N5008PThree Chicks Aviation LLC · Benton, LAS/N 24-11N5014PSky Valley Aviation LLC · Waverly, IAS/N 24-17N5017PPineapple Air LLC · Wilmington, DEBuilt 1957 · S/N 24-20N5020PThurston Steven C · Salisbury, NCBuilt 1958 · S/N 24-23N5029PJordan Walter B · Chehalis, WABuilt 1958 · S/N 2432N5034PNeufeld William J · Bostwick, FLBuilt 1958 · S/N 24-37N5045PMccarty Paul S · Wichita, KSBuilt 1958 · S/N 24-49N5048PBrown Mark E · Charlotte, NCBuilt 1958 · S/N 24-52N5050PBoucher Bobbi · Fredericksburg, VAS/N 24-54N5051PGrorud James R · Milbank, SDBuilt 1958 · S/N 24-55N5065PVeal Ted W · Homer, AKS/N 24-71N5066PDelaware Aviation LLC · Sidney, NYBuilt 1958 · S/N 24-72N5074PShingledecker Robert K II · Ozark, ARBuilt 1958 · S/N 24-80N5078PPutnam Andrew L · New Limerick, MEBuilt 1958 · S/N 24-84N5088PKesser Gilbert M · Culpeper, VABuilt 1958 · S/N 24-94N5091PSpicuzza Robert A · Waterford, MIBuilt 1958 · S/N 24-100N5093PAir Chutney LLC · Waynesboro, VABuilt 1958 · S/N 24-102N5114PParris David T · Virginia Beach, VABuilt 1958 · S/N 24-126N5115PSmith James Kelly · Newark, OHBuilt 1958 · S/N 24-127N5117PMarsteller Michael A · Lugoff, SCBuilt 1959 · S/N 24-130N5130PWhite Guy B · Waxahachie, TXBuilt 1958 · S/N 24-143N5132PMccormick Geoffrey D · Goodyear, AZBuilt 1958 · S/N 24-145N5136PDunn James F · Salem, INBuilt 1958 · S/N 24-150
Back to AD 59-07-05