OpenAirDocs.org
AD 2009-13-06 R1

Registered aircraft · 2,131

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

N4614PHull John W Jr · Palmdale, CABuilt 1960 · S/N 27-126N462DHFly Live Charter Inc · Fort Lauderdale, FLS/N 31-7952218N462TTAir Enterprises LLC · Dover, DEBuilt 1968 · S/N 27-4042N4630PGoodfellow Ian A · Palm Beach Gardens, FLBuilt 1960 · S/N 27-148N4631PO'Neill Daniel C · Tumwater, WAS/N 27-149N4636PV1 Iowa Aviation LLC · Des Moines, IAS/N 27-155N4642PColumbus Sign Co · Columbus, GAS/N 27-163N4644PFennema Alan A · San Jose, CABuilt 1960 · S/N 27-165N4650PCornejo Bernard J · Elko, NVS/N 27-173N4662PCorn Michael L · Wilmington, NCBuilt 1960 · S/N 27-185N4676PHuslig Brandon M · Carefree, AZBuilt 1960 · S/N 27-205N4678PRudloff Uwe K Trustee · Lake Village, INS/N 27-207N467JKSale Reported · St MaartenSale reportedS/N 274209N4691PWilliamsburg Air Service · Kingstree, SCBuilt 1960 · S/N 27-220N4696PPolhemus Christopher · Carmichaels, PABuilt 1960 · S/N 27-225N4699PGv Air Inc · Medford, ORBuilt 1960 · S/N 27-227N46ERAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 27-3649N46FAFox Aircraft LLC · Bethel, AKS/N 318152020N46HLGsp Air LLC · Sparta, NJBuilt 1985 · S/N 42-5527017N46MYBeach Air LLC · Boynton Beach, FLBuilt 1975 · S/N 31-7552039N46SDPacific Fleet Aviation LLC · Rochester, NYBuilt 1980 · S/N 27-8054040N4704PCarlson Brent · Medford, ORBuilt 1960 · S/N 27-232N4705PHam Edward E · Boring, ORBuilt 1960 · S/N 27-233N4714PKropf Jacob · Halsey, ORBuilt 1960 · S/N 27-243N4724PTnt Farms · Marana, AZS/N 27-252N4728PSheppard Harold DBA · Riverton, WYBuilt 1960 · S/N 27-257N4731PBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 27-261N473GGTiffin Aire Inc · Tiffin, OHS/N 31T-7820026N4750PKenefick Christopher Keith · Rosamond, CABuilt 1960 · S/N 27-288N4757PRenck Michael R · Red Rock, TXBuilt 1960 · S/N 27-297N4758PCole Gary L · Richmond, TXBuilt 1960 · S/N 27-274N4782POlson Allan K · Tarpon Springs, FLBuilt 1960 · S/N 27-338N4799PPlayer Dennis · Union Bridge, MDBuilt 1960 · S/N 27-359N47EEGt Aviation Solutions LLC · Mount Juliet, TNS/N 27-2009N47JFReeve Howard E · Minot, NDS/N 31T-8020031N47MKAztec Aviation Two LLC · Augusta, GABuilt 1973 · S/N 27-7305122N47RLUpstate Aircraft Leasing LLC · Wilmington, DEBuilt 1970 · S/N 27-4582N47ZGJep Air LLC · Jackson, WYBuilt 1985 · S/N 42-5527031N481SWFour Hills LLC - Piper Series · Plano, TXBuilt 1980 · S/N 31T-8104016N4823PWilliams Charles S · Pearland, TXS/N 27-389N4833PPacifica LLC · Grand Junction, COS/N 27-401N4843PSherrill L H · Tucson, AZBuilt 1961 · S/N 27-414N4851PTwin Air Assets LLC · Casper, WYBuilt 1961 · S/N 27-424N4853PSwan Aviation Ministries Inc · Baker, FLS/N 27-426N485EDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 27-3864N486MTNavy 8686 LLC · Boston, MABuilt 1985 · S/N 425527029N4883PMardis James T · Mechanicsburg, PABuilt 1961 · S/N 27-464N4893PTri-City Helicopter Services Inc · Richland, WABuilt 1961 · S/N 27-477N4895PKlein Barry A · Friday Harbor, WABuilt 1961 · S/N 27-482N4899PC E S Corporation · Charleston, WVRevoked, canceledBuilt 1961 · S/N 27-487
Back to AD 2009-13-06 R1