OpenAirDocs.org
AD 57-20-01

Registered aircraft · 187

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

N1103Schmidt Thomas P · Nunica, MIBuilt 1958 · S/N 7FC-234N123BKBuscombe Stanley G · Sacramento, CABuilt 1959 · S/N 7FC-331N228WVarona Pedro A · Lake Placid, FLBuilt 1958 · S/N 7FC-255N31TWHall Wendell W · Cheraw, SCS/N 7FC-170N3JZFreel Michael R · Cedarville, MIS/N 7FC-212N428CAJones Steven L · Winnebago, MNS/N 428N4838ERoberts Calvin D · Bluebell, UTS/N 7FC-295N4839EHeckman Burt W · Mcclave, COBuilt 1959 · S/N 7FC-296N4848EConcannon Michael V · Indianapolis, INBuilt 1959 · S/N 7FC-299N4857ESeverance Camden R · Milford, NHS/N 7FC-306N4864EMorgan Thomas A · Greenville, NCBuilt 1959 · S/N 7FC-309N4869EHogue James R Trustee · Spring Valley, OHBuilt 1959 · S/N 7FC-310N4870EWells Kris G · Barron, WIS/N 7FC-311N4872EDippold Lois M · Perry, MIBuilt 1959 · S/N 7FC-312N4873ERice Johnny D · Rosharon, TXBuilt 1959 · S/N 7FC-313N4874EJenkins Don C · Wymore, NEBuilt 1959 · S/N 7FC-314N4878EPoklar Norman A · Mount Orab, OHS/N 7FC-316N4884EPeck James M · Harrisburg, ARBuilt 1959 · S/N 7FC-317N4898EHagler Thomas J · Paradise, CABuilt 1959 · S/N 7FC-321N50778Sale Reported · Hernando, FLSale reportedBuilt 1961 · S/N 432N599SIron Pillar Properties Inc · Falkville, ALS/N 7FC-462N644MPPasztalaniec Matthew S · Monterey, CAS/N 7FC-192N678DWAnderson Timothy · Pilot Rock, ORBuilt 1957 · S/N 7FC-95N6NDLind Mitchell W · Polk City, FLBuilt 1958 · S/N 7FC-200N7480BBenkert Daniel D · Rapid City, SDBuilt 1957 · S/N 7FC-2N7496BHoldgate Frederick I · Englewood, FLS/N 7FC-4N7503BSale Reported · Rigby, IDSale reportedS/N 7FC-11N7507EBall Robert L · Clinton, OHBuilt 1958 · S/N 7FC-227N7508BCrane Kenneth W · Oak Ridge, TNBuilt 1957 · S/N 7FC-13N7513BWood Kent A · Holmes Beach, FLBuilt 1957 · S/N 7FC-17N7513ERag Wings And Radials Aircraft Leasing LLC · Georgetown, DEBuilt 1958 · S/N 7FC-233N7515BJeffryes Richard B · Creswell, ORBuilt 1957 · S/N 7FC-19N7517EVanherck Glen D · Bonne Terre, MOBuilt 1958 · S/N 7FC-236N7518BMaxwell Richard H · Grove City, PABuilt 1957 · S/N 7FC-23N7522BTailwheelin LLC · Richland, WAS/N 7FC-25N7526BTyree Chris L · Arley, ALBuilt 1957 · S/N 7FC-29N7526EKerlin Matthew D · Fredericksburg, VABuilt 1958 · S/N 7FC-238N7528BFairley Stephen M · Petal, MSBuilt 1957 · S/N 7FC-31N7529BTeck Roger M · Mayfield, NYBuilt 1957 · S/N 7FC-32N7532BRimck Lloyd F · Maricopa, AZBuilt 1957 · S/N 7FC-35N7533BJoe Dory Aviation LLC · Star, IDS/N 37-57N7534BMandan Enterprises LLC · Chester, CTBuilt 1957 · S/N 7FC-38N7534EMatta Figueroa Eduardo · Chapman, KSBuilt 1958 · S/N 7FC-243N7536ECheslik Michael S · Columbus, OHBuilt 1958 · S/N 7FC-244N7537BParker William Scott · Barnesville, GAS/N 7FC-41N7537EGallaway David P · Albany, ORS/N 7FC-245N7539EPierce Stephan L · Graham, TXBuilt 1958 · S/N 7FC-246N7540ECottrell Mark C · Leitchfield, KYBuilt 1958 · S/N 7FC-247N7541BWestfall James H · Bend, ORS/N 7FC-44N7542EBrasil John I · Lemon Grove, CAS/N 7FC-248
Back to AD 57-20-01