AD 72-02-06

Registered aircraft · 2,299

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

N1800XValentine Edward Lawson · Dallas, TXFirst renewal noticeBuilt 1964 · S/N 18255900N1801XClark Curtis S · New Carlisle, OHBuilt 1965 · S/N 18255901N1801ZGould Robert R Jr · Sterling, VABuilt 1962 · S/N 205-0001N1802FSantiago Ferdinand · Calhoun, GABuilt 1965 · S/N 21058702N1802ZSparks Timothy J · Jackson, MIBuilt 1962 · S/N 205-0002N1804FWaage Todd · Greenbush, MNBuilt 1965 · S/N 21058704N1806XBrowning Lonnie O IV · Allendale, SCS/N 18255906N1808XM&M Land Company LLC · Marietta, OHBuilt 1964 · S/N 18255908N1808ZFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVNon-citizen corporation, flight hours not reportedBuilt 1962 · S/N 205-0008N1809XMilburn Thomas D Trustee · Lompoc, CABuilt 1964 · S/N 18255909N1809ZCleared For Departure LLC · Kennewick, WABuilt 1962 · S/N 205-0009N1810ZRanzway Corp · Seattle, WABuilt 1962 · S/N 2050010N1811XAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1964 · S/N 18255911N1812XDavid Glen E · Ash Fork, AZS/N 18255912N1814FAlpine Cable And Construction Inc · Grand Junction, COBuilt 1965 · S/N 21058714N1817XSale Reported · Roseville, MNSale reported, pending cancellationBuilt 1965 · S/N 18255917N1819XGrant Steven T · Sellers, SCBuilt 1964 · S/N 18255919N181CPEighty1 Aviation LLC · Canton, GABuilt 1964 · S/N 18255766N181DHWinkler Jeffery L · Brush, COBuilt 1964 · S/N 206-0220N1820ZStaats Douglas E · Anchorage, AKBuilt 1962 · S/N 205-0020N1821SBailey Ralph E · Sikeston, MOBuilt 1962 · S/N 2050021N1821XCluer Brian L · Bodega, CABuilt 1964 · S/N 18255921N1822ZAhrens Kevin Michael · Cashmere, WABuilt 1962 · S/N 205-0022N1823XN1823x LLC · Middletown, DEBuilt 1964 · S/N 18255923N1825ZGreentek Inc · Oroville, CABuilt 1962 · S/N 205-0025N1827XFlatland Farms LLC · Hooker, OKBuilt 1964 · S/N 18255927N1828ZHorrocks Charles M · Blackfoot, IDBuilt 1962 · S/N 205-0028N1829XWise Dennis E · Battle Ground, WAS/N 18255929N182ARRyan Jeffrey W · Westminster, COBuilt 1964 · S/N 18255472N182CJJackson George K · Jonesboro, ARBuilt 1961 · S/N 18253671N182DBBender Flight LLC · Camano Island, WABuilt 1964 · S/N 18255607N182DHWills James M · Farmville, VABuilt 1962 · S/N 18253909N182GEGmr Leasing LLC · Lincoln, DEBuilt 1962 · S/N 18254299N182HAvquad Inc · Fort Collins, COBuilt 1965 · S/N 18255990N182JENunatak Air LLC · Fairbanks, AKBuilt 1962 · S/N 18254111N182JJJ & J Aero · Chuckey, TNBuilt 1962 · S/N 18254379N182KFPlante Matthew · Blackstone, MABuilt 1962 · S/N 18254358N182LDLutian Mark J · Raymond, MEBuilt 1965 · S/N 18256362N182LHHudspeth Lance A · Redmond, ORBuilt 1965 · S/N 18256305N182MService Oriented Aviation Readiness (Soar) · Bolivar, MOS/N 18255118N182SRBaldwin Steve · Kearney, MOBuilt 1965 · S/N 18256571N182TFHigh-Wing Aero LLC · Albertville, MNBuilt 1964 · S/N 18255617N182TPBurkeen Timothy Charles · Prescott, AZBuilt 1964 · S/N 18255245N182UKMarshall Christopher E · Boise, IDBuilt 1964 · S/N 18255359N182ULMedia Stew LLC · Carson City, NVBuilt 1964 · S/N 18255864N182WHSorensen Welding Inc · Mahnomen, MNS/N 18256208N182WLMckaye Thomas · Santa Paula, CABuilt 1964 · S/N 18255802N182WYWind River Flyers Inc · Pinedale, WYBuilt 1963 · S/N 18255160N182YHParker Nicholas · St Maries, IDBuilt 1965 · S/N 18256349N182YSYuba-Sutter Aviation Inc · Olivehurst, CABuilt 1963 · S/N 18254845
Back to AD 72-02-06