AD 2006-10-21

Registered aircraft · 44,908

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

N1277WRush Aviation Rentals Inc · Meridian, IDBuilt 2001 · S/N 172S8846N1277XDuke City Mooney LLC · Lakewood, COBuilt 1963 · S/N 150N127826350 LLC · Yorklyn, DES/N 17702387N1278JBallester Alexis R · Mayaguez, PRBuilt 1975 · S/N 278N1279XRegistered aircraftBuilt 1963 · S/N 152N127AKSwan Logistics LLC · Toledo, OHS/N 2059N127ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496035N127AVPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N 28-8490077N127BDRegistered aircraftBuilt 2022 · S/N 620-2022N127CGRegistered aircraftBuilt 2025 · S/N 41976N127DMAircraft Leasing LLC · Peoria, ILBuilt 2017 · S/N 30023N127EYoung John C · Olathe, KSBuilt 2001 · S/N 2146N127EMKrein Chris · Bismarck, NDS/N 121707N127GT7 Golf Tango LLC · Saint Petersburg, FLBuilt 2004 · S/N 3257343N127HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2003 · S/N 172S9532N127JNNewman Jimmie L · Davenport, FLBuilt 2007 · S/N 24735N127KHCentral Airlines Inc · Overland Park, KSBuilt 1961 · S/N 500B-1027-38N127KJSky Flowers Holding Group LLC · Sunrise, FLS/N 10248N127KWElizabeth City State University · Elizabeth City, NCBuilt 2005 · S/N 172S9827N127LFFisher Nicholis W · Springfield, LAS/N 27N127MDCosbie Lee R · Tuscumbia, ALBuilt 1963 · S/N 28-1503N127PMinard Robert Myron Jr Trustee · Laveen, AZBuilt 1997 · S/N 24672N127PSParsa Aviation LLC · Boca Raton, FLS/N 6010N127SAVintage Tailwheel LLC · Wilmington, DEBuilt 2006 · S/N 1026-2006N127SHWaverly R22 LLC · Oklahoma City, OKBuilt 2007 · S/N 4116N127SLGulf Coast Helicopters Inc · Pearland, TXBuilt 2003 · S/N 18281256N127TGEberle Brian J · Newnan, GABuilt 2005 · S/N 21321N127TZMeng-Hannan Construction Inc · Portland, ORBuilt 2000 · S/N 2108N127VGEvans James F · Columbus, GABuilt 1978 · S/N 32R-7885274N127WMMagnum Consulting Group Inc · Scottsdale, AZBuilt 1993 · S/N 1369N127XKilgore Sky LLC · Parker, AZBuilt 2004 · S/N 40.438N1280KChristiansen Aviation LLC · Wilmington, DEBuilt 2023 · S/N 172S13064N1280TCertified Equipment Inspections LLC · Washington, PABuilt 1972 · S/N 28R-7235253N1280XErlandson Michael D · Salt Lake City, UTS/N 153N1281KKirkwood Billie R · El Paso, TXBuilt 2011 · S/N 24143N1281QMaranatha Insurance Services Inc · Rancho Cucamonga, CABuilt 2006 · S/N 172S10333N12828Fulwiler Air LLC · Green Bay, WIBuilt 1961 · S/N 3023N1283HMurphy George W · Willow, AKS/N 15AC-299N1284NAbnc Air LLC · Wellington, FLS/N 28-7405076N1284WBethel Don G · Bossier City, LABuilt 1967 · S/N 28R-30304N1284ZDubose Alexander R · Durham, CABuilt 1961 · S/N TD-458N1285ROrbit Aviation LLC · Lakewood, CAS/N 31026N12868Gregg William V · Greensburg, PABuilt 1975 · S/N 17702390N1286JDillman Neal A · Davis, CABuilt 1975 · S/N 286N1286THeffelfinger Paul D · Seven Valleys, PABuilt 1972 · S/N 28-7205277N1287ECrown Coast LLC · Costa Mesa, CABuilt 2006 · S/N 172S10335N1287TBelle Casa Aero LLC · Tarpon Springs, FLBuilt 1972 · S/N 32-7240111N1289XConner James B · Mishawaka, INBuilt 1963 · S/N 162N1289YBravo Leasing LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9851N128AGarza Family LLC · Helena, MTBuilt 1967 · S/N 32-40354
Back to AD 2006-10-21