AD 2012-10-13

Registered aircraft · 13,306

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:2012-10-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:2012-10-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.

N4387DTravel Direct LLC · Montevideo, MNBuilt 1985 · S/N 46-8508040N4388MMalibu 88mike LLC · Duncanville, TXBuilt 1985 · S/N 46-8508047N438APWhiskey 340 LLC · Tucson, AZBuilt 1977 · S/N 340A0438N438CDSquibb Daniel · Xenia, OHBuilt 2005 · S/N 1404N438PCJaml Aviation LLC · Happy Valley, ORBuilt 2010 · S/N 3625N438SR10sm Clr LLC · Oklahoma City, OKBuilt 2007 · S/N 2567N43911Scud Runner LLC · Cape Coral, FLBuilt 1985 · S/N 46-8508059N4391EN4391e LLC · Scottsdale, AZBuilt 1985 · S/N 46-8508054N439NKSt Louis Aircraft Partners LLC · Saint Louis, MOBuilt 2004 · S/N 0919N439SFCarter Randy C · Poway, CABuilt 1995 · S/N 29-0039N43CPMountain View Industries LLC · Missoula, MTBuilt 1979 · S/N P21000398N43DAAero Management Holdings LLC · Hot Springs, ARBuilt 1976 · S/N 340A0112N43FMBaseline Digital Inc · Satellite Beach, FLBuilt 1998 · S/N 29-0139N43GWAero Development LLC · Mesa, AZBuilt 2023 · S/N L2K-322N43HWPiper Nicholas W · Nanjemoy, MDBuilt 2000 · S/N 29-0259N43KMSns Real Estate LLC · Portland, ORBuilt 2026 · S/N 11375N43KNSkyforge Holdings LLC · Asheville, NCBuilt 2026 · S/N 11438N43KYPinto Carlos Eduardo · Tucson, AZBuilt 1972 · S/N 21059563N43LDIrongate Aviation LLC · Raymond, NHBuilt 2021 · S/N 5093N43LP430lp LLC · Marlow, OKBuilt 2022 · S/N 8630N43MEEvans Matthew B · Granbury, TXBuilt 1978 · S/N P21000046N43MRFlight Contract Services Inc · Las Vegas, NVS/N 414A-0016N43QCAviation LLC · Kalispell, MTBuilt 1984 · S/N TJ-467N43TMMkt Development LLC · Venedocia, OHBuilt 2012 · S/N 3838N43WCcp Capital Holdings LLC · Newark, DEBuilt 2025 · S/N 10551N4402JBruton Paul · El Campo, TXBuilt 1980 · S/N T18803736TN440CDN440cd LLC · Williamsburg, VABuilt 2005 · S/N 1515N4414RKirk Ledoux · Stanwood, WABuilt 1979 · S/N U20605111N441BEDriftwood Aviation LLC · Northport, MIBuilt 1999 · S/N 0001N441CFDelcardayre J Sid · Richmond, VABuilt 2019 · S/N 1924N441FPHumphrey Marlon · Birmingham, ALBuilt 2026 · S/N 11207N441GWEugetech LLC · Bettendorf, IABuilt 2004 · S/N 1060N441TPUnited Contractors Inc · Costa Mesa, CABuilt 1978 · S/N 414A0057N441TTSunbird Airlines Inc · San Juan, PRBuilt 1981 · S/N 402C0441N441WPAero Holdings LLC · Williamston, SCBuilt 2026 · S/N 11413N4421RJ & B Aircraft Leasing LLC · Lufkin, TXBuilt 1985 · S/N 46-8508051N4422NValiair Lc Trustee · Casper, WYBuilt 1978 · S/N P21000099N4428CPayne Jeffrey C Trustee · Stockton, CABuilt 1980 · S/N EA-59N4429LShingebiss LLC · Independence, ORBuilt 1982 · S/N 21064647N442CCRaymond Andrew A · Crescent, IAS/N 414A0483N442EGGrotech Inc · Fresno, CABuilt 2018 · S/N 1716N442FMHogan Quinn H Trustee · Milwaukee, WIBuilt 1979 · S/N 414A0303N442PTAutodealersonly.Com Inc · Brunswick, GABuilt 1999 · S/N 30-0018N442SJRegistered aircraftBuilt 2006 · S/N 42521N442TTQualitair LLC Trustee · MichelstadtBuilt 2004 · S/N 1012N4435PRbr Investments Aviation LLC · Stanley, IDBuilt 2023 · S/N 9629N443AKBark Aviation LLC · Las Vegas, NVBuilt 2024 · S/N 10344N443CPBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 3296N443PFrederick Investment Corp · Raleigh, NCBuilt 1999 · S/N TH-1914N443PGCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11657
Back to AD 2012-10-13