OpenAirDocs.org
AD 52-01-08

Registered aircraft · 57

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:52-01-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:52-01-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.

N10195Deuchar Hillary · Brookings, ORS/N 562N10196Porter Kelton B · Homer, AKBuilt 1960 · S/N 340N1023GContinental Title Trust LLC Trustee · Wichita, KSBuilt 1953 · S/N 51-16307N1048PAviation Solution Experts LLC · St Marys, IAS/N 635N162DLLewkowicz Augusto D · Fort Lauderdale, FLS/N 224N162MCosta James Joseph · Tulare, CABuilt 1962 · S/N 238N16643Koch Kasey E · Bigfork, MTBuilt 1952 · S/N 346N172SMSedeyn Thomas Sr · Salem, NJBuilt 1950 · S/N 317N212WInternational Air Services Inc Trustee · Carson City, NVS/N 237N225REMoonshadow Aviation Inc · Wilmington, DES/N DLW3N245CHansen Christopher H · Durhamville, NYBuilt 1953 · S/N 324N263SSMadden Russell E · Graford, TXS/N 265N307AJSwashbuckle Air LLC · Anchorage, AKBuilt 1952 · S/N 426N330MLacy Glenn M · Bedford, VAS/N 287N33616Sale Reported · Lakeland, FLSale reportedBuilt 1955 · S/N 720N38763International Air Services Inc Trustee · Carson City, NVS/N 497N3877LJarrell Stephen L · Edgewood, NMBuilt 1954 · S/N 674N410NRHaynes Cory W · Heyburn, IDBuilt 1961 · S/N 2244N41319Aspinwall W Frank · Kingsland, GAS/N 433N4254AJames David R · Wayne, MIBuilt 1950 · S/N 229N47242Pockrus Pat B · Mineral Wells, TXBuilt 1952 · S/N 491N4733CTaz Air Service Inc · Middletown, DES/N 260N4785CBorszich Claude C Jr · Phoenix, AZBuilt 1952 · S/N 312N4977EWyllie Ashton R J Trustee · Thornton, NHBuilt 1951 · S/N 254N5025JAnderson Mike DBA · Muskogee, OKS/N 726N5072RFogelson Robert A · Benton City, WAS/N 613N5104VOutka Wade R · Aberdeen, SDBuilt 1963 · S/N JR-1N5301VVrem Kelly L · Sutton, AKBuilt 1953 · S/N 563N5306VDonnelly Matthew J · Romulus, NYS/N 632N5311VBotello Michael C · Rancho Mirage, CABuilt 1955 · S/N 703N538ACHardy John S · Fort Worth, TXBuilt 1953 · S/N 538N57UPatten Jeffery D · Rapid City, SDS/N 286N613HLHood Paul D · Broken Arrow, OKS/N 283N62275Selzer Robert S · Anchorage, AKS/N 420N62329Puch Len D · New Boston, MIS/N 558N6331DGilbreath Tony C · Olustee, OKS/N 213N6417VStokes Teddie V · Holly Pond, ALBuilt 1952 · S/N 417N64764Registration Pending · Riverbank, CARegistration pendingBuilt 1952 · S/N 489N67016Grein Darrell L · Cypress, TXS/N 492N6744CKiska Farms Inc · Pasco, WAS/N 556N68962Pockrus Pat B · Mineral Wells, TXS/N 104N69085Clarcq Richard D · Cohocton, NYS/N 103N7212HCarriveau Vincent A · Franksville, WIBuilt 1956 · S/N 212N727JRMiddlestetter Matt · Camp Sherman, ORBuilt 1953 · S/N 571N7299Classic Rotors Museum · Ramona, CABuilt 1955 · S/N 729N8109HRagan Randall R · Sarasota, FLBuilt 1949 · S/N 109N8116HThompson John A Trustee · Carson City, NVBuilt 1949 · S/N 116N8117HWilliams Charles S · Anacoco, LABuilt 1949 · S/N 117N8178HRotor Wing Nuts LLC · Kansas City, MOBuilt 1950 · S/N 178N8180HPockrus Pat B · Mineral Wells, TXBuilt 1950 · S/N 180
Back to AD 52-01-08