AD 60-16-01
Registered aircraft · 61
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:60-16-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:60-16-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.
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:60-16-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:60-16-01') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N11863Schwendenman Zachary M · West Covina, CAN125MBLewallen William J · Arizona City, AZN14PWAudemus Inc · Newport News, VAN150PRAerojet Servivces Inc · Aurora, CON1597Registration Pending · Laguna Beach, CARegistration pendingN165ZAHoffman Carl A · Newnan, GAN167ZAAgather V Neils · Fort Worth, TXN1850North Shore Aviation Services Corp · Waialua, HIN189RHoughton Justin · North Ferrisburg, VTN18DTriple Four Mike LLC · Ponte Vedra Beach, FLN213DEVintage Wings Aircraft LLC · Centerpoint, INN213SPBeech O Sphere LLC · Casper, WYN241DBarron Aviation LLC · Perry, MON2625Aero Specialists Inc · Eloy, AZN2833GVintage Aero Inc · Brandon, FLN310GBMission Air Aviation LLC · Roanoke, VAN325DSteggs Jeff E · Imperial, NEN3666GDream Weaver Aviation LLC · East Berlin, PAN40074American Airpower Heritage Flying Museum Inc · Dallas, TXN404CKN404ck LLC · Anchorage, AKN447DMMorlock Inc · Crossville, TNN45GCAshworth Corp Inc · Geneseo, NYN45SKPlane Fun Inc Tr Trustee · Snellville, GAN480PPlane Fun Inc Tr Trustee · Snellville, GAN491DMRst Aviation LLC · Vero Beach, FLN496DMGoff Richard A · Plevna, MTN5180VSunzeri Jeffery J · Hollister, CAN60493Cam Air · Caldwell, IDN606JWHeartland Aviation Inc · Alliance, NEN606PARegistration Pending · Kingsford, MIRegistration pendingN6100CErickson Kirk E · Warroad, MNN611WPScilleppi Gregory · Bainbridge Island, WAN6495DPreserve Aviation History LLC · Cape Coral, FLN71GJSkydive Greene County Inc · Xenia, OHN75BBWarbirds 1 LLC · Chattanooga, TNN75QVr Jet LLC · Goshen, INN7694CMiddle Keys Experimental Aircraft Association Inc · Marathon Shores, FLN7805CAtropos Group Inc · Arlington, VAN7826LTri-State Warbird Museum · Batavia, OHN7916ABeechcraft Heritage Museum Inc · Tullahoma, TNN80240Beech 18 Holdings LLC · Sheridan, WYN80323Bachus & Son Inc · Wichita, KSN8389HPoplar Grove Airmotive Inc · Poplar Grove, ILN8504Clay-Klein LLC · Indianapolis, INN8640EGrimes Flying Lab Foundation · Urbana, OHN8720RMorrison Neil E · Port Townsend, WAN87690Montana Sitework LLC · Rainbow City, ALN87692Hill Vincent T · Bucyrus, KSN876NSteeves Brian G · Wahpeton, NDN912KKEllis Ronald G · N Fort Myers, FL
Back to AD 60-16-01