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.

N1202JAldrich Curtiss · Aguila, AZBuilt 1974 · S/N 202N1204JLucas Rici · Columbus, GABuilt 1974 · S/N 204N1210JBerry Stephen B · Dunn, NCBuilt 1974 · S/N 210N1211JChristensen Allen · Clayton, CABuilt 1974 · S/N 211N1212JDobmeier Mark M · Grand Forks, NDS/N 212N1215JRinggold Rolf E · Circle Pines, MNBuilt 1974 · S/N 215N1218JWeeks Wesley J · Iowa Park, TXS/N 218N121RFRafamedia LLC · Stamford, CTBuilt 1976 · S/N 13048N1226JMores Glenn S · Boxford, MABuilt 1974 · S/N 226N1231JMattson Paul · Chula Vista, CAS/N 231N1240JRinger Kevin L · Grants Pass, ORS/N 240N1242JLouisiana Aviation LLC · Marksville, LABuilt 1974 · S/N 242N1246JRegistration Pending · Parrott, VARegistration pendingBuilt 1976 · S/N 505N1247JSalazar Raul · Bradenton, FLBuilt 1975 · S/N 247N1250JFranchise Aviation LLC · Sparta, NJS/N 250N1254JWidener William J · Chillicothe, ILBuilt 1975 · S/N 254N1270JWendell Matthew D · Telford, PABuilt 1976 · S/N 507N127XYLaap LLC · Clancy, MTBuilt 1976 · S/N 14039N128ADWahl Flying LLC · Germantown, WIBuilt 1974 · S/N 219N12FPElliott James R · Denton, TXBuilt 1974 · S/N 238N12XGCommander Aviation LLC · Williamsburg, VABuilt 1977 · S/N 14237N1322Temple Donald G · Colorado Springs, COFirst renewal noticeBuilt 1976 · S/N 14165N1322JChesley Boyd A · Cottonwood, AZS/N 513N1328JO'Brien Patrick J · Santa Paula, CABuilt 1976 · S/N 13038N1350JFish Associates Inc Trustee · Wilmington, DEBuilt 1976 · S/N 516N136DBuckeye Ridge Farm LLC · Vidalia, GABuilt 1978 · S/N 14361N1382Air Cowboy LLC · Roca, NES/N 13000N1393JMcnamara Bradley W · Seattle, WAS/N 523N1409JLuther Steven P · Pensacola, FLS/N 510N1416JSettles Richard · Lupton, MIS/N 531N1429JWooley Michael W · Navarre, FLBuilt 1976 · S/N 429N143RCRegistration Pending · Santa Fe Springs, CARegistration pendingBuilt 1977 · S/N 533N1476JDodgen Charles W · Thomaston, GABuilt 1976 · S/N 476N1479JAbel Paul D · Kalispell, MTS/N 539N1483JMcmillan Gavin · Tarpon Springs, FLBuilt 1977 · S/N 542N1487JCook Kevin C · Noank, CTS/N 543N14AFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 13258N14SGBorts Gerald S · Altadena, CABuilt 1978 · S/N 14434N1501JStarkey David T · La Jolla, CABuilt 1976 · S/N 13001N1506JHumbles Frank Forrest · Charleston, SCBuilt 1976 · S/N 13003N1583JSweigard Daniel J · Euless, TXBuilt 1976 · S/N 13013N1586JLuczak Thomas W · Agoura Hills, CABuilt 1976 · S/N 13016N158TZBoney George C Jr Trustee · Chapin, SCBuilt 2000 · S/N 20037N166DAAnca Aircraft LLC · Fort Myers, FLBuilt 1976 · S/N 14166N1718JDavidson Craig H · Heber City, UTBuilt 1976 · S/N 13008N1723JWhittaker Charles B · Tryon, NCBuilt 1976 · S/N 13024N1752JHolbrook Kevin B · Norman, OKBuilt 1976 · S/N 13025N177LBClark Glenn W · Mary Esther, FLBuilt 1979 · S/N 13309N1797JMcmillan Law Firm Apc · La Mesa, CABuilt 1976 · S/N 13027N17JFWorley William N IV · Ormond Beach, FLBuilt 1979 · S/N 14503
Back to AD 2011-07-13