OpenAirDocs.org
AD 2011-07-13

Registered aircraft · 523

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

N4863WKoch Christopher P · Batavia, NYS/N 14193N4866WSixty Six Whiskey LLC · Key Largo, FLS/N 14196N4867WSzolusha Scott A · Woodstock Valley, CTS/N 14197N4871WBerkey Eric · Hot Springs, ARS/N 14201N4874WInternational Air Services Inc Trustee · Carson City, NVS/N 14204N4875WPc Air Ventures Ltd · Wilmington, DES/N 14205N4882WForrest Lawrence C · Granbury, TXS/N 14212N4887WBern Paul J · Apple Valley, CABuilt 1977 · S/N 14217N4892WTagliareni Joseph R · Lake Hopatcong, NJS/N 14222N4895WTaylor Mark W · Amherst, NYBuilt 1977 · S/N 14225N4897WGibson Kurt A · Fort Smith, ARBuilt 1977 · S/N 14227N4898WSorce Angelo J · Dandridge, TNBuilt 1977 · S/N 14228N4911W3js Aviation LLC · Wilmington, DEBuilt 1977 · S/N 14235N4912WBaur Peter · Placida, FLS/N 14236N4918WGorman Robert W · Oklahoma City, OKS/N 14242N4921WForward Aero LLC · Thomasville, PABuilt 1977 · S/N 14245N4928WL D Aviation LLC · Chesapeake, VABuilt 1977 · S/N 14251N4931WPerry Clifton · Lacon, ILBuilt 1977 · S/N 14254N4934WS&T Aircraft LLC · Lewes, DEBuilt 1977 · S/N 14256N4940WKitt Consulting LLC · Boardman, OHBuilt 1977 · S/N 14262N4943WKaufman Michael A · Upland, CAS/N 14265N4944WHickory Hill Partners LLC · College Station, TXS/N 14266N4945WBlueline Flight Systems LLC · Orlando, FLBuilt 1977 · S/N 14267N4947WBloom Kevin Lynn · Freeport, FLBuilt 1977 · S/N 14269N4959WSteverson Jill T · Newhebron, MSBuilt 1977 · S/N 14279N495TCRegistered aircraftS/N 20004N4961WDreka Todd W · Wasilla, AKS/N 14281N4963WCaride Jose A · Spring Hill, FLS/N 14283N4965WMorcom Aviation Services Inc DBA · Everett, WAS/N 14285N4968WBower Jeffrey L · Glenwood, NJS/N 14288N4976WQualitair LLC Trustee · MichelstadtBuilt 1977 · S/N 14296N4977MLuscher Christopher S · Everett, WAS/N 540N49809Anderson Erik G · Deerfield Beach, FLBuilt 1976 · S/N 14055N4981WJahn Kenneth Kris · Shingle Springs, CABuilt 1977 · S/N 14301N4983WPappa Whiskey Victor LLC · Brandon, MSBuilt 1977 · S/N 14303N4984FChuprinko John A · Centerburg, OHBuilt 1977 · S/N 14246N4988SMosley Jerry · Las Vegas, NVS/N 13011N4990WKennedy Terry P · Kingman, AZBuilt 1977 · S/N 14310N4993WHamilton Robert A · Owensboro, KYBuilt 1977 · S/N 14313N4995WAnderson Ryan L · Wadena, MNS/N 14315N49ABFay William E · Washougal, WAS/N 13066N4JYSuzuki Shoji DBA · San Jose, CABuilt 1976 · S/N 13080N4LYScott D Bonk LLC · Fort Myers, FLBuilt 1993 · S/N 14594N500DSBarletta Mark S · Winter Haven, FLBuilt 1977 · S/N 14231N50AYInternational Air Services Inc Trustee · Carson City, NVS/N 14527N50BGStilson Scott · Ivins, UTBuilt 1976 · S/N 14184N511CABas Part Sales LLC · Greeley, COS/N 14035N512SFSky West Aviation Inc Trustee · Albuquerque, NMS/N 20026N515CADeerpark Valley Investments LLC · Georgetown, TXBuilt 1976 · S/N 14059N519CASakitumi LLC · Wilmington, DES/N 14239
Back to AD 2011-07-13